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
Natalie DeeringNatalie Deering 

Checkbox and Picklist Validation Rule

Hi Everyone!

I am trying to create a validation rule that makes several picklist fields mandatory when a checkbox field is selected.

Thanks in advance!
Balaji BondarBalaji Bondar
Hi Natalie,

Add condition like: 
AND(    
    checkbox == TRUE,
    ISBLANK(TEXT(picklist))
)
Important :
If this is what you were looking for then please mark it as a "SOLUTION" or You can Click on the "Like" Button if this was beneficial for you.
Natalie DeeringNatalie Deering
Thank you Balaji! Worked like a charm!! Is there a different formula if you have a multi-picklist field?
Balaji BondarBalaji Bondar
No above formula will work.
Natalie DeeringNatalie Deering
This is my formula:
AND(Field_Deployment__c ==TRUE, ISBLANK(TEXT(  Field_Engineer__c )))
This is the error kicking bak=ck:
Error: Field Field_Engineer__c is a multi-select picklist field. Multi-select picklist fields are only supported in certain functions
@anilbathula@@anilbathula@
Hi Natalie Deering

Try these validation rule:-

AND(Field_Deployment__c ==TRUE, ISBLANK( Field_Engineer__c ))

Thanks
Anil.B
 
C. Praveen kumarC. Praveen kumar

Try this:-
AND(Field_Deployment__c ==TRUE, ISPICKVAL(Field_Engineer__c, ''))