3

I am trying to create a WFR formula that will set a date/time when statuses are moved into specific statuses on the case. Can someone help with how to format this so when ever any one of the statuses below are selected the rule will fire?

AND(
ISCHANGED( Status ),
ISPICKVAL(Status, "Processed"),
ISPICKVAL(Status, "Additional Processing In Progress ")
ISPICKVAL(Status, "Employer Verification Pending")
ISPICKVAL(Status, "Hearing Scheduled")
))
1
  • 1
    Remember Status cannot simultaneously be two different values. Your current rule looks for such a scenario.
    – Adrian Larson
    Feb 20, 2018 at 18:41

1 Answer 1

4

It looks like you need a nested OR to pick up on any one of the statuses, along with the change to that field:

AND( ISCHANGED( Status ), 
     OR(ISPICKVAL(Status, "Processed"), 
        ISPICKVAL(Status, "Additional Processing In Progress "),
        ISPICKVAL(Status, "Employer Verification Pending"),
        ISPICKVAL(Status, "Hearing Scheduled")))

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .