Sign Up ›
  • Jesse M
  • NEWBIE
  • 10 Points
  • Member since 2021
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
SOLVED
3 replies

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!
SOLVED
3 replies

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!