Help

Re: If Checkbox is ticked, ignore other outputs and return value

Solved
Jump to Solution
636 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Ploy
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

Ploy
5 - Automation Enthusiast
5 - Automation Enthusiast

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])

Ploy
5 - Automation Enthusiast
5 - Automation Enthusiast

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!