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
kjunkjun 

if checkbox is true then values from picklist can't be selected on save

I have a checkbox named Currently__c

and a picklist named Choices___c with 5 text values: 
One
Two
Three
Four
Five

If a user leaves the checkbox as true and chooses any of the below-listed values from the picklist and attempts to save the record,  I need a validation rule that should error out on save.

Two
Three
Four
Five

is this possible?
VinayVinay (Salesforce Developers) 
Try below snippet.
  
AND(Currently__c= true,  OR(ISPICKVAL(Choices___c,'Two' ),ISPICKVAL(Choices___c,'Three' ),ISPICKVAL(Choices___c,'Four' ),ISPICKVAL(Choices___c,'Five' ))

Thanks,
Malika Pathak 9Malika Pathak 9
AND(Currently__c= true,  OR(ISPICKVAL(Choices___c,'Two' ),ISPICKVAL(Choices___c,'Three' ),ISPICKVAL(Choices___c,'Four' ),ISPICKVAL(Choices___c,'Five' ))