Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

If Checkbox is ticked, ignore other outputs and return value

Topic Labels: Formulas
Solved
Jump to Solution
639 5
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

I’ve been trying to work this out for hours but I’m afraid my knowledge of airtable formulas is quite nascent.

I’ve got this current formula:

IF(
{Due}="",
“”,
IF(
AND(
DATETIME_DIFF({Due},TODAY(),‘hours’) >= 12,
DATETIME_DIFF({Due},TODAY(),‘hours’) <= 48
),
“Due Soon”,
IF(
IS_BEFORE({Due},TODAY()),
“Past Due”,
IF(
IS_SAME({Due},TODAY()),
“Due Today”,
“Upcoming”
)
)
)
)

Which gives me different values depending on how much time is left in the “Due” column. I’m trying to add another variable that says that if checkbox column “Done” is ticked, disregard all the above formula and return value “Complete”. How can I go about doing this please?

1 Solution

Accepted Solutions

You’ve already nailed nested IF statements. So just add it as your very first IF statement.

IF({checkbox_field}=“checked”,“Complete”,[put the rest of your formula here])

See Solution in Thread

5 Replies 5

To evaluate whether a checkbox field is checked, evaluate for the word “checked” in that field.

Thanks for your response!

Sorry, for the dumb question. How do I edit my formula to do that?

You’ve already nailed nested IF statements. So just add it as your very first IF statement.

IF({checkbox_field}=“checked”,“Complete”,[put the rest of your formula here])

Hi ScottWorld, Thank you so much for your feedback. It was accepting the formula but not presenting the result. I had to change “checked” to “1” and it fixed it. Thanks so much for your time!!!

Oh nice, you just taught me something there! Thank you! :slightly_smiling_face: I actually thought it would evaluate the word “checked”, which is the text data that it is actually typing into the field!