Need to create a formula that checks 2 parameters

  • 0
  • 1
  • Question
  • Updated 10 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

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

Posted 10 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,402 Points 50k badge 2x thumb
This should work

[Escalation] = "4HR" and [2 HR Notification] = true
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
shorter:

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

But to be honest I think the OP needs a form rule because I don't think  [4 HR Notification] is a formula field.
Photo of Stephanie

Stephanie

  • 676 Points 500 badge 2x thumb
I'm not very good with formulas. What I have now is

If(Contains([Escalation], "4HR"), true)
How do I change this?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,402 Points 50k badge 2x thumb
I suggest that you try my formula above. It turns out in Quickbase you don’t actually need to make an
IF statement when the result is going to be true or false. You can just make a statement and if the statement evaluates to true then the checkbox will get checked.

I am in the car right now so it’s a little hard to type but if I get a chance I will write out a longer formula that will make more sense to you. But meanwhile why don’t you just try a new field with my formula and see if it works.
Photo of Stephanie

Stephanie

  • 676 Points 500 badge 2x thumb
I did. It doesn't work.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,402 Points 50k badge 2x thumb
Does it give a syntax error? If so please post your formula and the syntax error.
Photo of Stephanie

Stephanie

  • 676 Points 500 badge 2x thumb
No error. I tried both formulas
  • [Escalation] = "4HR" and [2 HR Notification] = true
  • [Escalation] = "4HR" and [2 HR Notification]
Both returned no results - didn't check the box.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,402 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

  • 676 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

  • 65,402 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

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

Forrest Parker

  • 1,016 Points 1k 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

  • 65,402 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 #.