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 件の回答
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)
)