validation rule that locks an opportunity when closed except for one field

Question

I have a validation rule that keeps anyone except for administrators from editing an opportunity after it is closed. Now I need to make two fields editable by everyone after the opportunity is closed. How do I do that?

Heres my validation rule

AND(ISPICKVAL((StageName),"Closed/Won - 100%"),

NOT(OR(

$User.Id = "00534000009IAAD",

$User.Id = "005340000097c6g",

$User.Id = "00580000003wipf",

$User.Id = "005800000074nof",

$User.Id = "00534000009qNA4",

$User.Id = "00534000009a4KN",

$User.Id = "00534000009tCPi")))

Error Message Not allowed to be edited once at closed won 100%. Only systems admin allowed to edit

Deepak K Anand · Accepted Answer

Like this -

AND(
NOT(ISCHANGED(Field1__c)),
NOT(ISCHANGED(Field2__c)),
ISPICKVAL((StageName),"Closed/Won - 100%"), 
NOT(OR( 
$User.Id = "00534000009IAAD", 
$User.Id = "005340000097c6g", 
$User.Id = "00580000003wipf", 
$User.Id = "005800000074nof", 
$User.Id = "00534000009qNA4", 
$User.Id = "00534000009a4KN", 
$User.Id = "00534000009tCPi")))

Steve Molis · Answer

So you want to write a Validation Rule that evaluates ALL of of the standard and custom fields on the Opportunity, and if any field (other than those 2) are edited by any User (other than the ones in your list) they get an error?

validation rule that locks an opportunity when closed except for one field

Data Management

Related Learning

More Help