# Need to create a formula that checks 2 parameters

• 0
• Question
• Updated 1 year ago
• In Progress
• (Edited)
I need a formula that says
When [Escalation] = 4HR and [2 HR Notification] is checked, check [4 HR Notification]
Thank you.
• 676 Points
• I wish formulas were in plain english

Posted 1 year ago

• 0
• 75,144 Points
This should work

[Escalation] = "4HR" and [2 HR Notification] = true
• 75,144 Points
Can you look at a single record and tell me what is in the field [Escalation] and what field type it is, and same for the other field?
• 676 Points
[Escalation] is a text field - it contains text '2HR', '4HR', '8HR', 24HR'
• 75,144 Points
That should work.  I don't mind having a quick look to see what the problem is, if you like, or else you will need to put in a support ticket.  I can be reached via the contact info on my website QuickBaseCoach.com
• 676 Points
I just sent an invite
• 1,332 Points
Are you putting it in an if statement?

`if([Escalation] = "4HR" and [2 HR Notification] = True,True,False)`
• 75,144 Points
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 #.