+ Start a Discussion
HNT_NeoHNT_Neo 

More than 1 value in a picklist that requires a validation rule

I'm trying to create a validation rule that when a picklist item is selected instead of the default value "XYZ", the AcitivityDat field is required if left blank when trying to save a record. I tried to create the VR that would reequire me to add 2 more picklist values to make it work. So, if a user selects, Left Message, Left Voicemail, or Emailed, the ActivityDate must not be blank, the VR should prompt them to fill in the ActivityDate field.
 
AND(ISPICKVAL(Call_Status__c, "Left Message"),ISBLANK(ActivityDate))

this syntax only works if the user selects Left Message, but I have 2 other values for the Call_Status__c picklist field. The default value is XYZ when a record is created. However, if a user selects another value besides XYZ, and tries to save the record without entering a value in the ActivityDate field, the VR should prompt them to fill in the Acitivity Date.

Thank you in advance!
Best Answer chosen by HNT_Neo
Prithviraj_ChavanPrithviraj_Chavan
AND(!ISPICKVAL(Call_Status__c, "XYZ"),ISBLANK(ActivityDate))
just add ! symbol before is Pickval function and "XYZ"

All Answers

Prithviraj_ChavanPrithviraj_Chavan
AND(!ISPICKVAL(Call_Status__c, "XYZ"),ISBLANK(ActivityDate))
just add ! symbol before is Pickval function and "XYZ"
This was selected as the best answer
HNT_NeoHNT_Neo
Worked prefectly, thank you!
Prithviraj_ChavanPrithviraj_Chavan
Hi Neo,
Thanks for selecting best answer ..