避免銷售倒退嚕或跳躍前進的驗證公式
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | AND( ISPICKVAL(StageName, "Closed Lost") ,OR( AND(ISPICKVAL( PRIORVALUE( StageName ), "Prospecting"), NOT(ISPICKVAL(StageName, "Qualification"))), AND(ISPICKVAL( PRIORVALUE( StageName ), "Qualification"), NOT(ISPICKVAL(StageName, "Needs Analysis"))), AND(ISPICKVAL( PRIORVALUE( StageName ), "Needs Analysis"), NOT(ISPICKVAL(StageName, "Value Proposition"))), AND(ISPICKVAL( PRIORVALUE( StageName ), "Value Proposition"), NOT(ISPICKVAL(StageName, "Id. Decision Makers"))), AND(ISPICKVAL( PRIORVALUE( StageName ), "Id. Decision Makers"), NOT(ISPICKVAL(StageName, "Perception Analysis"))), AND(ISPICKVAL( PRIORVALUE( StageName ), "Perception Analysis"), NOT(ISPICKVAL(StageName, "Proposal/Price Quote"))), AND(ISPICKVAL( PRIORVALUE( StageName ), "Proposal/Price Quote"), NOT(ISPICKVAL(StageName, "Negotiation/Review"))), AND(ISPICKVAL( PRIORVALUE( StageName ), "Negotiation/Review"), NOT(ISPICKVAL(StageName, "Closed Won"))), AND(ISPICKVAL( PRIORVALUE( StageName ), "Closed Won"), NOT(ISPICKVAL(StageName, "Closed Won"))), AND(ISPICKVAL( PRIORVALUE( StageName ), "Closed Lost"), NOT(ISPICKVAL(StageName, "Closed Lost")))) ) |
