Sign Up ›
  • ANUDEEP PYNA
  • NEWBIE
  • 0 Points
  • Member since 2023
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
1 replies

Validation rule on opportunity to move stage by stage in backwards

Hi All,

I have configured opportunity record should be moved stage by stage in order using below syntax. I have query that, can we back trace the record in descending order. For eg: Stage - 4 to Stage-3 and Stage-3 to Stage-2 etc.,

OR(
AND(ISPICKVAL(StageName, "Stage 1 - Identified Opportunity"), NOT(ISPICKVAL( PRIORVALUE(StageName) , "Stage 0 - Prospect"))),
AND(ISPICKVAL(StageName, "Stage 2 - Response"), NOT(ISPICKVAL( PRIORVALUE(StageName) , "Stage 1 - Identified Opportunity"))),
AND(ISPICKVAL(StageName, "Stage 3 – Selection"), NOT(ISPICKVAL( PRIORVALUE(StageName) , "Stage 2 - Response"))),
AND(ISPICKVAL(StageName, "Stage 4 – Negotiation"), NOT(ISPICKVAL( PRIORVALUE(StageName) , "Stage 3 – Selection")))