Skip to main content
I added a validation to my opportunity that when it's in the Funding or Allocation stage the user can not go to the previous stage. That works but now I can't close the opportunity. I thought it may have had something to do with the order of the stage of closed won and lost. But I don't understand how that can be when the closing stages are the last stages. Any suggestions. I have my validation rule below:

 

CASE( StageName ,

 

"Funding",7,

 

"Allocation",8,

 

0)

 

 <

 

CASE(PRIORVALUE(StageName) ,

 

"Funding",7,

 

"Allocation",8,

 

0)
3 réponses
  1. 9 juil. 2020, 18:06
    What is you closed stage?

     

    AND(

     

    NOT(IsClosed),

     

    CASE( StageName ,

     

    "Funding",7,

     

    "Allocation",8,

     

    0)

     

     <

     

    CASE(PRIORVALUE(StageName) ,

     

    "Funding",7,

     

    "Allocation",8,

     

    0)

     

    )

     

    This will work!