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 

Picklist field required based on another picklist

Hello 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
try this
 
AND(
ISPICKVAL(Status,'Unqualified'),ISBLANK(TEXT(Rating)))

 

All Answers

Raj VakatiRaj Vakati
try this
 
AND(
ISPICKVAL(Status,'Unqualified'),ISBLANK(TEXT(Rating)))

 
This was selected as the best answer
Raj VakatiRaj Vakati
AND(
ISPICKVAL(Status,"Unqualified"),ISBLANK(TEXT(Rating)))