function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Amanda ShowersAmanda Showers 

Validation Rules for Picklist fields

User-added image

I need the "Former Customer" Field (which is a picklist) to become required when the "Type" is marked as a "Prospect" (also a picklist). What is the formula to do this?
Best Answer chosen by Amanda Showers
kevin lamkevin lam
AND(ISBLANK(TEXT(Former_Customer__c)),
          ISPICKVAL(Type__c, "Prospect"))

All Answers

kevin lamkevin lam
AND(ISBLANK(TEXT(Former_Customer__c)),
          ISPICKVAL(Type__c, "Prospect"))
This was selected as the best answer
Erin Ryan 15Erin Ryan 15
Thanks Kevin,
 I just used this formula after a lot of  frustrating testing. Worked perfectly.