Need to create a formula that checks 2 parameters

• 0
• 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.
• 676 Points
• I wish formulas were in plain english

Posted 10 months ago

• 0

QuickBaseCoach App Dev./Training, Champion

• 65,422 Points
This should work

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

Ⲇanom the ultimate (Dan Diebolt), Champion

• 30,044 Points
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.
• 676 Points
I'm not very good with formulas. What I have now is

If(Contains([Escalation], "4HR"), true)
How do I change this?

QuickBaseCoach App Dev./Training, Champion

• 65,422 Points
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.
• 676 Points
I did. It doesn't work.

QuickBaseCoach App Dev./Training, Champion

• 65,422 Points
Does it give a syntax error? If so please post your formula and the syntax error.
• 676 Points
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.

QuickBaseCoach App Dev./Training, Champion

• 65,422 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'
[2 HR Notification] and [4 HR Notification] are formula checkboxes

QuickBaseCoach App Dev./Training, Champion

• 65,422 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,016 Points
Are you putting it in an if statement?

`if([Escalation] = "4HR" and [2 HR Notification] = True,True,False)`

QuickBaseCoach App Dev./Training, Champion

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