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
Derek Bennett 5Derek Bennett 5 

Required Field Based on Picklist

Im trying to create a validation rule that makes one Picklist Field required when another Picklist Field is selected. 
For example when the Picklist Field(Status) has the value "Unqualifed"  theres another picklist field that should be required called "Rating"
Here's my sytax so far, i keep getting errors, any advise?

AND(ISPICKVAL(Status,'Unqualified'),ISNULL(Rating))
Best Answer chosen by Derek Bennett 5
Raj VakatiRaj Vakati
AND(
ISPICKVAL(Status,"Unqualified"),ISBLANK(TEXT(Rating)))

 

All Answers

Maria PezmanMaria Pezman

Try changing the single quotes/apostrophes to quotes. ( ' -> " )

 

Raj VakatiRaj Vakati
AND(
ISPICKVAL(Status,"Unqualified"),ISBLANK(TEXT(Rating)))

 
This was selected as the best answer