You need to sign in to do that
Don't have an account?
HNT_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.
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!
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!
just add ! symbol before is Pickval function and "XYZ"
All Answers
just add ! symbol before is Pickval function and "XYZ"
Thanks for selecting best answer ..