+ Start a Discussion
SecureSecure 

Validation Rule Help Please

Hey Guys, Im trying to create a quick validation rule for when someone picks a value from picklist A, any value, then Picklist B becomes required. This is what I have so far.

 

 

 

AND(ISPICKVAL(Picklist_A__c, ""), ( ISPICKVAL(Picklist_B__c, "")))

 

I just can't figure out how to make the Picklist A statement say "If I pick anything", not just something specific. Thanks for the help.

 

Best Answer chosen by Admin (Salesforce Developers) 
skodisanaskodisana

Hi,

 

Use the below format.

 

AND(TEXT(Picklist_A__c)!='', TEXT(Picklist_B__c)='')

 

Thanks,

Kodisana

All Answers

skodisanaskodisana

Hi,

 

Use the below format.

 

AND(TEXT(Picklist_A__c)!='', TEXT(Picklist_B__c)='')

 

Thanks,

Kodisana

This was selected as the best answer
SecureSecure

Thanks man. Worked perfect.