Skip to main content
Question

Need to create a formula that checks 2 parameters

  • June 22, 2018
  • 0 replies
  • 168 views

I need a formula that says
When [Escalation] = 4HR and [2 HR Notification] is checked, check [4 HR Notification]
Thank you.
This topic has been closed for replies.

This should work

[Escalation] = "4HR" and [2 HR Notification] = true

I spoke to Stephanie on a GTM and her situation was quite a bit more complex than was outlined in her post, though it was vaguely alluded to in the headline.  She in fact has multiple records for the same Ticket# and data from those multiple records needed to be combined into a formula text result.

I showed Stephanie how to make a table of unique Ticket numbers and maintain it by importing a summary report into that table after each data import of a fresh batch of tickets.   Then we did some summary fields and a formula to combine the result of the tickets with the same Unique ticket #.