Need to create a formula that checks 2 parameters

  • 0
  • 1
  • Question
  • Updated 5 months 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.
Photo of Stephanie

Stephanie

  • 596 Points 500 badge 2x thumb
  • I wish formulas were in plain english

Posted 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
This should work

[Escalation] = "4HR" and [2 HR Notification] = true
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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?
Photo of Stephanie

Stephanie

  • 596 Points 500 badge 2x thumb
[Escalation] is a text field - it contains text '2HR', '4HR', '8HR', 24HR'
[2 HR Notification] and [4 HR Notification] are formula checkboxes
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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  
Photo of Stephanie

Stephanie

  • 596 Points 500 badge 2x thumb
I just sent an invite
Photo of Forrest Parker

Forrest Parker

  • 598 Points 500 badge 2x thumb
Are you putting it in an if statement?

if([Escalation] = "4HR" and [2 HR Notification] = True,True,False)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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 #.