Skip to main content
Mark Loftis (EZMedSupply) a posé une question dans #Collaboration
Hello!

 

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 réponses
  1. 23 oct. 2020, 23:29
    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 )

    )