Skip to main content
I have a custom object with a picklist field with a handful of values.  Once the field is marked "Completed" I do not want users to be able to change it unless they are either "System Administrator" or "Operations Team."  How should I implement this?  At the moment, I have this: 

 

 

 

ISPICKVAL(PRIORVALUE(Status__c), "Completed")&& ($Profile.Name <> "System Administrator"|| $Profile.Name <> "Operations Team")

 

Thanks, 

 

Mike 
4 Antworten
  1. 27. Dez. 2019, 21:43
    Hi Michael,

     

    Use this:

    AND(

    $Profile.Name <> "System Administrator",

    $Profile.Name <> "Operations Team",

    ISCHANGED(Status__c),

    TEXT(PRIORVALUE(Status__c)) = "Completed"

    )