I am a noob and need help with a validation rule please. I have 14 stages in Lead object and would like to prevent (1) skipping stages and (2) moving backwards on a stage...BUT only apply the formula to stages 1-8, after stage 8 doesn't matter you can skip 8 to 10 move back 11 to 9 I don't care...but I don't want any monkey business for stages 1-8...Linear progression and no backward activity. I would also need an exception for stage 13 (unqualified) so that I can skip to that stage no matter what.
17 Antworten
I would try doing this is 2 Rules Rule 1 (blocks skipping)
AND(
ISCHANGED( Status ),
TEXT(Status) <> 'Unqualified 13',
CASE(Status ,
"New",1,
"Personal Info",2,
"Coverage Info",3,
"Run pVerify",4,
"Doctor Info",5,
"Build Rx",6,
"Fax Rx",7,
8 )
>
CASE(PRIORVALUE(Status) ,
"New",1,
"Personal Info",2,
"Coverage Info",3,
"Run pVerify",4,
"Doctor Info",5,
"Build Rx",6,
"Fax Rx",7,
8 ) + 1
)
Rule 2 (blocks rollback)AND(
ISCHANGED( Status ),
CASE(Status ,
"New",1,
"Personal Info",2,
"Coverage Info",3,
"Run pVerify",4,
"Doctor Info",5,
"Build Rx",6,
"Fax Rx",7,
8 )
<
CASE(PRIORVALUE(Status) ,
"New",1,
"Personal Info",2,
"Coverage Info",3,
"Run pVerify",4,
"Doctor Info",5,
"Build Rx",6,
"Fax Rx",7,
8 )
)