Picklist Dependency - Answers - Salesforce Trailblazer Community
Ask Search:
Michelle WhiteMichelle White 

Picklist Dependency

Hello All, 

I'm trying to create a picklist, once the specific value is selected I want it to prompt two extra fields required to be completed. 

Can you please lead me in the right direction..

Thanks, Michelle
Best Answer chosen by Jayson (salesforce.com) 
Ahilesh RagavanAhilesh Ragavan
You need a Validation rule like this:
AND(
TEXT(Picklist_Field__c) = "VALUE",
OR(
ISBLANK(Required_Field_1__c),
ISBLANK(Required_Field_2__c)
)
)
Note: If any one of those required fields is a picklist then wrap the field API names with TEXT(), like ISBLANK(TEXT(Required_Field_1__c))
 

All Answers

Ahilesh RagavanAhilesh Ragavan
You need a Validation rule like this:
AND(
TEXT(Picklist_Field__c) = "VALUE",
OR(
ISBLANK(Required_Field_1__c),
ISBLANK(Required_Field_2__c)
)
)
Note: If any one of those required fields is a picklist then wrap the field API names with TEXT(), like ISBLANK(TEXT(Required_Field_1__c))
 
This was selected as the best answer
Ravinder PaulRavinder Paul
Hi Michelle,

For this case scenario you may need to write a validation rule instead of dependency picklist value. Check post like:
https://success.salesforce.com/answers?id=9063A000000pPKmQAM
https://developer.salesforce.com/forums/?id=906F00000009fmeIAA
Michelle WhiteMichelle White
Thank you