Need to create a formula that checks 2 parameters
I need a formula that says When [Escalation] = 4HR and [2 HR Notification] is checked, check [4 HR Notification] Thank you.
Forum Discussion
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 #.
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 #.