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
joe27joe27 

picklist and checkbox rule

hi all,,

 

I am looking for a vaidation rule for a checkbox to a picklist.

 

So if the checkbox is ticked then the picklist is required

Any help would be great

 

Cheers

joe

 

 

 

Best Answer chosen by Admin (Salesforce Developers) 
Madhan Raja MMadhan Raja M

Try this Formula:

 

IF( Checkbox__c=TRUE && ISPICKVAL( Picklist__c , ''), TRUE, FALSE)

 

 

If a reply to a post answers your question or resolves your problem, please mark it as the solution to the post so that others may benefit.

 

 

 

Madhan Raja M

 

All Answers

Madhan Raja MMadhan Raja M

Try this Formula:

 

IF( Checkbox__c=TRUE && ISPICKVAL( Picklist__c , ''), TRUE, FALSE)

 

 

If a reply to a post answers your question or resolves your problem, please mark it as the solution to the post so that others may benefit.

 

 

 

Madhan Raja M

 

This was selected as the best answer
Madhan Raja MMadhan Raja M

If you are using custom Picklist then the best way is to use Field Dependencies.

 

Goto> Field Dependencies and make Checkbox as Controlling field and Picklist as Dependent field.

 

If a reply to a post answers your question or resolves your problem, please mark it as the solution to the post so that others may benefit.

 

Madhan Raja M
joe27joe27

cheers Madhan that worked prefectly
phiberoptikphiberoptik

Hi Joe - please mark the right answer as the solution. Thanks!