+ Start a Discussion
Vipin K 10Vipin K 10 

Make picklist field Required based on other Picklist Field Value

HI All,

I have 2 custom picklist fields, Eg : abc__c(New, Open, Inprogress) and xyz__c(High, Medium, Low, Average)
If the value of picklist abc__c is 'New' , xyz__c should not be 'Required' and for all rest of values on abc__c , xyz__c should be Required 

Need an validation rule for this.. 

Thanks!!
Amit Singh 1Amit Singh 1
Ok use below formula for validation rule.
 
AND(NOT(ISPICKVAL( abc__c, "New")),ISBLANK(TEXT( xyz__c )))
Let me know if this do the trick :)

Thanks!
Amit Singh
 
sagarika bsagarika b
Hi,

I think We can achieve this By using Field Dependency also,
Controlling Filed:Abc_c
Dependent Field: xyz_c
for "New" --> Don't  add any values,
for remaining--> to add all values.

Hope it helpful to you
 
BestRegrads
Sagarika
 
Akhil AnilAkhil Anil
Hi Vipin,

The formula for your validation rule would be simply this
 
AND(
NOT(ISBLANK(TEXT(abc))),
NOT(ISPICKVAL(abc__c, "New")),
ISBLANK(TEXT( xyz__c ))
)

Kindly mark it as an answer if that works !