Using Formulas to create a Task status based on st...

[Layne]

I have been using the really helpful formula in this airtable article to have a status of done, complete, and in-progress for my project management base: https://support.airtable.com/hc/en-us/articles/221104988-Conditional-formulas-with-emoji

My formula currently looks like this:

IF({Done} = 1, “ :white_check_mark: Done​:white_check_mark:”,IF(IS_BEFORE({Due Date}, TODAY()), “ :alarm_clock: OVERDUE​:alarm_clock:”,“ :thumbs_up: In-progress​:+1:”))

However, I would really like to divide the In-progress into tasks that are currently in-progress (keeping status. as is) and tasks that are upcoming (start date is after today, basically). This is what I want:

:white_check_mark: Done :white_check_mark: : IF({Done} = 1, “ :white_check_mark: Done :white_check_mark: ”
:thumbs_up: In-progress :thumbs_up: : Start Date=before today and Due Date=After today
:alarm_clock: OVERDUE :alarm_clock: : Start Date = before today and Due Date=before today
:clock2: Upcoming :clock2: : Start Date= after today

I have tried so many different ways to nest another condition in there, and I just can’t make it work on my own… Would someone please help me out here?

[Bill_French]

Hi Layne and welcome to the community!

Layne:

I have tried so many different ways to nest another condition in there

Yeah, these nested IFs are difficult to dial in.

Recommendation:

1. Copy your formula into a text editor and logically organize it so you can see the flow of the conditions; this always seems to help with complex and dependent conditionals.
2. Consider using Switch().