+ 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' ))