I want to create a workflow, which should fire only when i change my pick list value from a particular value to another.

Example: pick list field status has values a, b, c, d and e. Now i want to send an Email only when the value is changed from B to C .

What i was trying is

If(isPicklistValue(status__c, 'B'), IF(ischanged(status__c), If(isNow(isPicklistValue(status__c, 'c'), true, false)), false), false)

But it is not working.


Try this, it makes use of the PRIORVALUE function and here is what it does

if the current value of picklist is c AND if the previous value was b then return true else false.

if( AND(ISPICKVAL(status__c,'c'), ISPICKVAL(PRIORVALUE(status__c),'B')),true,false )
| improve this answer | |
  • Hello Rajiv, thanks for the reply. But i'm getting an error saying, @PRIORVALUE function may not be used in this type of formula. – Rahul rvj Apr 14 '15 at 10:21
  • what is criteria that you have defined for the worflow? is it "created, and every time it’s edited"? – Rajiv Bhatt Apr 14 '15 at 10:30
  • yes, i have changed the criteria to "Created, and every time it's edited" and the error was gone. But the workflow is not working. – Rahul rvj Apr 14 '15 at 10:32
  • also please note the update in the formula, we need to use PRIORVALUE inside ISPICKVAL for picklist value – Rajiv Bhatt Apr 14 '15 at 10:32
  • After using the PRIORVALUE inside ISPICKVAL for picklist value, the workflow worked. – Rahul rvj Apr 14 '15 at 10:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.