Skip to main content
I know this question has been asked several times and I have tried all suggestions I could find without any luck.  I want to allow ONLY the System Administrator and the SPARTA Manager to have the ability to move Opportunities to a previous stage.  I tried the code below but it still will not let either profile move them backwards.  Help!!  Thanks

 

AND( 

 

CASE(StageName , 

 

"Qualified", 1, 

 

"Sponsor Analysis", 2, 

 

"Evaluation", 3, 

 

"Verbal Commitment", 4, 

 

"Closed Won", 5, 

 

"Closed Lost", 6,0) 

 

< 

 

CASE(PRIORVALUE(StageName) , 

 

"Qualified", 1, 

 

"Sponsor Analysis", 2, 

 

"Evaluation", 3, 

 

"Verbal Commitment", 4, 

 

"Closed Won", 5, 

 

"Closed Lost", 6,0),

 

OR(

 

$Profile.Name <> "System Administrator",

 

$Profile.Name <> "SPARTA Manager"))
답변 3개
  1. 2017년 11월 20일 오후 4:38
    Hi Sandy,

     

    You are very close excepy both the Profiles should be inside the AND statement as opposed to OR statement

    AND(

    $Profile.Name <> "System Administrator",

    $Profile.Name <> "SPARTA Manager",

    CASE(StageName ,

    "Qualified", 1,

    "Sponsor Analysis", 2,

    "Evaluation", 3,

    "Verbal Commitment", 4,

    "Closed Won", 5,

    "Closed Lost", 6,0)

    <

    CASE(PRIORVALUE(StageName) ,

    "Qualified", 1,

    "Sponsor Analysis", 2,

    "Evaluation", 3,

    "Verbal Commitment", 4,

    "Closed Won", 5,

    "Closed Lost", 6,0)

    )