function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Gwen ONeill 9Gwen ONeill 9 

Validation Rule - Picklist dependent on date

I'm trying to create a Validation rule that if you add or update a date, then you must select one of the picklist options.  Looking for suggestions to make it work.  Here's what I tried - it's not working but I tried!

AND (
OR ( 
 NOT( ISBLANK (Last_Employer_Meeting__c), 
ISPICKVAL(Meeting_Interaction_Type__c, "Email"),
ISPICKVAL(Meeting_Interaction_Type__c, "Phone"),
ISPICKVAL(Meeting_Interaction_Type__c, "Webinar/Virtual"),
ISPICKVAL(Meeting_Interaction_Type__c, "ON-Site")
)))
AnkaiahAnkaiah (Salesforce Developers) 
Hi Gwen,

try with below 
AND (
 NOT( ISBLANK (Last_Employer_Meeting__c), 
ISBLANK(Meeting_Interaction_Type__c))

If this helps, Please mark it as best answer.

Thanks!!
Gwen ONeill 9Gwen ONeill 9
I tried that and a few alterations, but I continue to get "missing ')'".  Not sure where I went wrong.
Shri RajShri Raj
AND(
    NOT(ISBLANK(Last_Employer_Meeting__c)),
    OR(
        ISPICKVAL(Meeting_Interaction_Type__c, "Email"),
        ISPICKVAL(Meeting_Interaction_Type__c, "Phone"),
        ISPICKVAL(Meeting_Interaction_Type__c, "Webinar/Virtual"),
        ISPICKVAL(Meeting_Interaction_Type__c, "ON-Site")
    )
)