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
    Remember Status cannot simultaneously be two different values. Your current rule looks for such a scenario. – Adrian Larson Feb 20 '18 at 18:41
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")))
| improve this answer | |

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.