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 what I want to achieve is, if the picklist
Level__c is either set to
Closed, the opportunity record can only be edited by the
For some reason though, the validation rule also triggers, when I want to set the
Closed. But this is not what I want.
Any idea what's wrong with the validation rule?