if pick-list value of Lead Status is not equal to "ABC" i want to execute workflow rule. If it is equal to "ABC" it shouldn't run the rule. How do i achieve this in formula field. I tried using ISPICKLIST VALUE, but couldn't figure it out.

appreciate the help in advance.


1) When you create the workflow rules select "Run this rule if the following" criteria are met instead of formula evaluates to true.

2) Select your field (picklist)

3) Select not equal to operator

4) Choose the value you're comparing against ("ABC") in your case


If you're using this in combination with other logic and you must use formula, the following formula should work:


  • Unfortunately, i can't use that option. I have few other criteria that i'm including this with. Should have mentioned in the text :). Thanks for the response. – user7307 Mar 24 '14 at 23:13
  • Can you use the filter logic or you must use formula? I've edited the answer for the formula. – Boris Bachovski Mar 24 '14 at 23:15
  • 1
    This is great. Thanks! NOT(ISPICKVAL('Status', 'ABC')) is perfect. – Joshua Dance Mar 22 '16 at 21:02

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.