Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
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")
))
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")))
Statuscannot simultaneously be two different values. Your current rule looks for such a scenario.