I am trying to write a workflow rule on case when priority increases. We have 4 picklist values(P1,p2,p3,p4) on priority.
Example: When priority changes from p3 to p2 or p2 to p1. and using 2nd option on evaluation criteria.
OR(AND( ISCHANGED(Priority), ISPICKVAL(PRIORVALUE(Priority), "P3"), ISPICKVAL((Priority),"P2"))
OR( AND( ISCHANGED(Priority), ISPICKVAL(PRIORVALUE(Priority), "P2"), ISPICKVAL((Priority),"P1"))) )
If I am comparing with priority value with previous value there would lot of scenarios to be covered whenever priority is increased. Is there any other way to handle this scenarios in workflow rule ?
Once the formula is true i am doing a field update with NOW() value.
Any help is appreciated.!