Need to create a formula that checks 2 parameters
I need a formula that says When [Escalation] = 4HR and [2 HR Notification] is checked, check [4 HR Notification] Thank you.
Forum Discussion
This should work
[Escalation] = "4HR" and [2 HR Notification] = true
[Escalation] = "4HR" and [2 HR Notification] = true
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.
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.