Question about project status formula

593 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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!

Screenshot 2021-07-27 103728

2 Replies 2

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!