• Mark Greene 19
  • NEWBIE
  • 0 Points
  • Member since 2020

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 0
    Replies
Hi,

I need to make an exception to my validation rule that allows for users to skip to Closed Lost stage without getting my prevent skipping stages validation rule error message. Any ideas how how to tweak this. Ideally, user would have to be in at least stage 2/Still Qualifying Opportunity in order to skip all the way to Closed Lost. 

See formula in its current form: 

CASE( StageName ,
"SQLs to be allocated",1,
"Still Qualifying Opportunity",2,
"Requirements Captured",3,
"Proposal Generated",4,
"Negotiation",5,
"Deal Committed",6,
"Closed Won",7,
"Closed Lost",7,0)
>
CASE(PRIORVALUE( StageName ) ,
"SQLs to be allocated",1,
"Still Qualifying Opportunity",2,
"Requirements Captured",3,
"Proposal Generated",4,
"Negotiation",5,
"Deal Committed",6,
"Closed Won",7,
"Closed Lost",7,0)
+1