You need to sign in to do that
Don't have an account?
Jesse M
Formula Operator question
I want to create a formula that sends out a specific email alert after a case has been re-opened - I want it to go something like this.
ISPICKVAL([Case].Status, "Open"),
ISPICKVAL(PRIORVALUE([Case].Status), "Resolved (User Confirmed)"),
OR
ISPICKVAL(PRIORVALUE([Case].Status), "Resolved (CS Confirmed)"),
OR
ISPICKVAL(PRIORVALUE([Case].Status), "Resolved (User Unconfirmed)"),
OR
ISPICKVAL(PRIORVALUE([Case].Status), "Closed"),
But Im having trouble in the placements of OR and the relevant syntax. Can anyone help the proper format of the code above?
Thank you!
ISPICKVAL([Case].Status, "Open"),
ISPICKVAL(PRIORVALUE([Case].Status), "Resolved (User Confirmed)"),
OR
ISPICKVAL(PRIORVALUE([Case].Status), "Resolved (CS Confirmed)"),
OR
ISPICKVAL(PRIORVALUE([Case].Status), "Resolved (User Unconfirmed)"),
OR
ISPICKVAL(PRIORVALUE([Case].Status), "Closed"),
But Im having trouble in the placements of OR and the relevant syntax. Can anyone help the proper format of the code above?
Thank you!
Hi, Jesse! So I think you want this:
All Answers
Try this :-
If this work, kindly mark it as best answer.
Regards,
Priya Ranjan
Unfortunately, that doesn’t work as the email alert goes out whenever any of those statuses are changed.
Im looking for the email alert to go out when a case has gone to the open status, but only when it was one of the previous statuses listed in priorvalue. I appreciate your continued assistance.
Hi, Jesse! So I think you want this: