I have a small problem.
I need to send an email using workflow, if a picklist value changes to or from one specific value.
I used 'priorvalue' to obtain the 'from' value, which updates a custom field, and it's working correctly. I just need some help on the 'to' part.
From: ISPICKVAL(PRIORVALUE( Driver_type__c ),
"CBD")
3 respuestas
Ah, so you need to introduce an OR clause.
Something like
And(ISCHANGED(Driver_type__c),
OR(ISPICKVAL(PRIORVALUE( Driver_type__c ), "CBD"),
ISPICKVAL(Driver_type__c , "CBD")))
I have not tested this to see if it will validate so you may have to tweak it a little (removing/adding commas and/or parenthesis).
This should get what you are looking for.