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
SteveO1993SteveO1993 

Validate a blank picklist field when another picklist has specific values

Hi, I am having a little difficulty with a validation rule I am working on.  What I am trying to do is validate a blank field entitled "Sales Region" when the Account Type has 3 specific values, however I am having difficulties getting it to work.  Any help would be greatly appreciated.  Here is the sample I was working with:
 
AND(OR(ISPICKVAL( Type , "Value 1"),ISPICKVAL( Type , "Value 2"),ISPICKVAL( Type , "Value 3")), ISPICKVAL(  Sales_Region__c  , "") )
 
Thanks!
 
SteveO1993SteveO1993

Hi All, disregard this prevous post, I found out what the problem was (there was an extra space in the picklist value that went unnoticed.  So this formula above works.