Workflow rule on case when priority increases

Question

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.!

Answer 1

If you labelled your priorities with numbers:

• 1 - Urgent
• 2 - High
• 3 - Normal
• 4 - Low

Then it's pretty simple:

VALUE(LEFT(TEXT(PRIORITY),1)) < VALUE(LEFT(TEXT(PRIORVALUE(PRIORITY)),1))

This converts the current and previous values to text, takes the left character, converts that to a number, and finally compares the two.

If you're using a different labeling system, you can use CASE instead:

CASE(PRIORITY,"Urgent",1,"High",2,"Normal",3,4) <
CASE(PRIORVALUE(PRIORITY),"Urgent",1,"High",2,"Normal",3,4)