+ Start a Discussion
GoJoyGoJoy 

Validation Rule on a PickList selection

Hi,
I would like to create a validation rule so that only Sales Rep and Systems Admins can modify a picklist field not inside Sales or any others.
Field name is:  Did meeting happen?
Picklist choices are: Yes, No

Here is my validation rule and it's not working correctly.  Can you help?

AND(
OR (
ISPICKVAL( Did_meeting_happen__c, "Yes"),
ISPICKVAL(Did_meeting_happen__c, "No")),
$Profile.Name = "Sales User")||
$Profile.Name = "Systems Admin")
Lalit Mistry 21Lalit Mistry 21
Try adding below condition to AND clause.
ISCHANGED(Did_meeting_happen__c)
Rahul BoinepallyRahul Boinepally
You have used '=' which makes system admin and sales user NOT to modify the picklist value. Try below and see if it works.
AND(
ISCHANGED(Did_meeting_happen__c),
OR($Profile.Name <> "Sales User"),
$Profile.Name <> "Systems Admin"))