This is my first go round with writing a workflow rule and am struggling to find correct syntax. Our Salespeople who generated a lead (Salesperson__c - a contact lookup field) want to get an email when the Status (Status) of the lead they brought in changes.

So I first tried Status= ISCHANGED(field). No luck, so then I tried ISCHANGED(Status).

Neither worked because it's a picklist I believe.

Do I need to use a ISPICKVAL formula? If so, does someone know correct syntax for this?

Lead Status Values

enter image description here

My updated formula is:

TEXT(Status) != TEXT(PRIORVALUE(Status))

But it gives this error:

Error: Function PRIORVALUE may not be used in this type of formula


The reason for the error is because of your Workflow evaluation criteria

You need it to be: rule evaluation criteria is set to "Every time a record is created or edited

@AdrianLarson already answered this once before.

  • Not the original issue, but good work actually reading the error message! :P – Adrian Larson Jan 6 '17 at 5:43

Set your your Workflow evaluation criteria to 'created, and every time it's edited' There you can use ISCHANGED(Status) Function Also. when i change my Workflow evaluation criteria to 'created, and every time it's edited' it works for me

  • Thanks for all the help everyone. My issue has been solved! – Alex Jan 6 '17 at 17:45

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.