I am looking to get a validation rule that will stop users from editting an Opportunity once the Stage in is Closed Won or Closed Won Renewal with the EXCEPTION of a field (as this is related to a process on process builder) and profiles system adminstrator or data administator.
This is my rule so far (however this is still allowing all users to edit closed won Opportunities but works with the field (ACV_GBP_New__c) exception.
AND(
(OR (
ISPICKVAL(StageName, "Closed Won"), ISPICKVAL(StageName, "Closed Won Renewal"))),
NOT(OR(
$Profile.Name = "System Administrator",
$Profile.Name = "Data Administrator")) ,
ISBLANK(ACV_GBP_New__c)
)
4 respuestas
Hi - the code works without having the exception of profiles in (So with the field only as the exception) - however does not work together?
