Skip to main content

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?

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


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?


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”,mput the rest of your formula here])


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



IF({checkbox_field}=“checked”,“Complete”,mput 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!!!


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! 🙂 I actually thought it would evaluate the word “checked”, which is the text data that it is actually typing into the field!


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



IF({checkbox_field}=“checked”,“Complete”,mput 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 

Reply