Need to create a formula that checks 2 parameters

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.

I'm not very good with formulas. What I have now is

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

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.

I did. It doesn't work.

Does it give a syntax error? If so please post your formula and the syntax error.

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.

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?

[Escalation] is a text field - it contains text '2HR', '4HR', '8HR', 24HR'
[2 HR Notification] and [4 HR Notification] are formula checkboxes

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  

I just sent an invite