I have a custom picklist field called 'Ops Lead' on the Opportunity Page.
I would like this picklist to be editable only by Account Management.
I wrote the following Validation Rule. It does not work. Can you please help me rewrite it. Thanks for your time.
AND(
ISCHANGED( Ops_Leads_Picklist__c ),
Ops_Leads_Picklist__c= TRUE,
$Profile.Name <> "Account Management"
)
6 answers
Please try the below
AND(
$Profile.Name <> "Account Management",
OR(
AND(
ISNEW(),
NOT(ISBLANK(TEXT(Ops_Leads_Picklist__c)))
),
ISCHANGED( Ops_Leads_Picklist__c ),
)
)
instead of a Validation rule, why dont you make this field Readonly for all Profiles other than Account Management Profile.
