Skip to main content
Solved

If Checkbox is ticked, ignore other outputs and return value

  • May 11, 2020
  • 6 replies
  • 139 views
P

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?

Best answer by ScottWorld

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

6 replies

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • May 11, 2020

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

P
  • Ploy
  • Author
  • New Participant
  • May 11, 2020

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?

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • Answer
  • May 11, 2020

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

P
P
  • Ploy
  • Author
  • New Participant
  • May 11, 2020

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!!!

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • May 11, 2020

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!

P
C
Forum|alt.badge.img+2

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


IF({Yes/No}=“true",([Cost*.075]))
I want to have tax added to certain items in my price list - how can i use the formula you created for that?  I have tried multiple variations 
Terms & ConditionsAccessibility statement