function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ 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.. 

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 :)

Amit Singh
sagarika bsagarika b

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
Akhil AnilAkhil Anil
Hi Vipin,

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

Kindly mark it as an answer if that works !