Question about project status formula

[Brooke_Hilliard]

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!

[Alexey_Gusev]

Hi,
i don’t know much about tutorial videos, but on the first sight,
i would suggest this article

Airtable Support

How to write nested IF statements

Structuring nested IF statements On its own, an IF function can only have two results—either the logical argument is true, or the logical argument is false. Putting an IF function inside of another...

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.

[Brooke_Hilliard]

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