I have the following validation rule:
AND(
$Profile.Name <> 'System Administrator',
OR(
ISPICKVAL(PRIORVALUE(Level__c), "Archived"),
ISPICKVAL(PRIORVALUE(Level__c), "Closed")
)
)
This validation rule is on the opportunity object, and basically, what I want to achieve is, if the picklist Level__c
is either set to Archived
or Closed
, the opportunity record can only be edited by the System Administrator
.
For some reason though, the validation rule also triggers, when I want to set the Level__c
to Archived
or Closed
. But this is not what I want.
Any idea what's wrong with the validation rule? Tia