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.