Skip to main content
Topics#Data ManagementFrage von Alastair Batchelor
Alastair Batchelor (Thomsons Online Benefits) fragte in #Data Management
10. Okt. 2014, 10:58

Validation Cry for Help!

I dont know if its Friday or that I'm just terrible at validation rules but... why doesn this not work? 

 

AND( 

 

ISPICKVAL(StageName, "Initial Discovery"), 

 

NOT(OR( 

 

ISPICKVAL(PRIORVALUE(StageName), "Solution Mapping"), 

 

ISPICKVAL(PRIORVALUE(StageName), "Solution Validation"), 

 

ISPICKVAL(PRIORVALUE(StageName), "Quote & Negotiation"), 

 

ISPICKVAL(PRIORVALUE(StageName), "Contract Closed"), 

 

ISPICKVAL(PRIORVALUE(StageName), "Closed Lost") 

 

)) 

 

)

 

Its meant to stop users from moving an oportunity back to Initail Discovery if teh stage is already at any of the following ones.

 

Appreciate your help in advance
4 Antworten
  1. Chris Edwards (Iscaforce Solutions)
    10. Okt. 2014, 11:11
    I don't think you need the NOT(), do you?

     

    AND( 

     

    ISPICKVAL(StageName, "Initial Discovery"), 

     

    OR( 

     

    ISPICKVAL(PRIORVALUE(StageName), "Solution Mapping"), 

     

    ISPICKVAL(PRIORVALUE(StageName), "Solution Validation"), 

     

    ISPICKVAL(PRIORVALUE(StageName), "Quote & Negotiation"), 

     

    ISPICKVAL(PRIORVALUE(StageName), "Contract Closed"), 

     

    ISPICKVAL(PRIORVALUE(StageName), "Closed Lost") 

     

    )

     

    )
Antwort schreiben...
0/9000