Skip to main content

I saw this formula on one of the tutorials on Airtable’s website and would like to use it but can’t figure out how to create the formula in Airtable. Can someone help me please? Thank you!


I circled the formula in the screenshot below. Any help would be greatly appreciated!


Hi,

i don’t know much about tutorial videos, but on the first sight,

i would suggest this article



also check ’ Conditional formulas with emoji’ in the same link.

Sometimes, it’s better to use SWITCH instead of “nested IF”, but in that case, i guess it’s smth like IF(Status=‘completed’, “Completed!”, IF (days till due>0, “on track”,"Overdue)) or maybe a bit more options included.

Hi,

i don’t know much about tutorial videos, but on the first sight,

i would suggest this article



also check ’ Conditional formulas with emoji’ in the same link.

Sometimes, it’s better to use SWITCH instead of “nested IF”, but in that case, i guess it’s smth like IF(Status=‘completed’, “Completed!”, IF (days till due>0, “on track”,"Overdue)) or maybe a bit more options included.


Thank you Alexey! These articles helped me a lot, I appreciate it!

Reply


Terms & Conditions