Skip to main content
Topics#Data ManagementErin Shimko's Question
Erin Shimko asked in #Data Management
Dec 3, 2014, 1:51 PM

How can I restrict access to update to closed stages (won/lost)?

I am trying to set up a validation rule that restricts any users (besides System Administrator) from updating opportunities to Won.  Here is the formula I am using but I keep getting the Syntax error. Missing ")".  What am I missing?

 

AND(

 

ISCHANGED(StageName)

 

ISPICKVAL(StageName,"D-Won"),

 

($Profile.Name  <> "System Administrator")
8 answers
  1. Sunil Sarilla (M&G Investments)
    Dec 3, 2014, 1:55 PM
    Hi Erin,

     

    you can try the below

     

    AND(

     

    ISCHANGED(StageName),

     

    ISPICKVAL(StageName,"D-Won"),

     

    $Profile.Name  <> "System Administrator"

     

    )
Write an answer...
0/9000