I need to figure out how to evaluate in a Workflow Rule if a Case's Status WAS Solved, and then moved to Open, fire a Field Update.

Any suggestions?

ISPICKVAL(PRIORVALUE(status),"Solved") && ISPICKVAL(status,"Open")

And make sure Rule criteria is set as created, and every time it's edited.

In case you select created, and any time it's edited to subsequently meet criteria then that formula will not compile at all.

  • Is there ever any danger of this type of workflow rule using up too many actions within salesforce (since it fires literally everytime a case is updated) and causing problems? – Sidereal Aug 9 '17 at 22:08
  • 1
    You can add other suitable logic like ISCHANGED – Santanu Boral Aug 9 '17 at 22:18

You can just use the AND and PRIORVALUE functions in addition to ISPICKVAL:

    ISPICKVAL(PRIORVALUE(Status), 'Solved'),
    ISPICKVAL(Status, 'Open')

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.