formula for status column using symbols based on end and target dates

QueryQuill

Hello,

I would like the status column (set to red and green, ball symbols) to automatically update based on task due today vs target date. Here is what I would like:

If end date is not past target date then status is green

If end date is past target date then status is red

Could someone help with the formula?

Thank you in advance!

Jen Castillo

Do you want it based on the current date, or is there a "task due today" column?

If there is a task due today column:

=IF([target date]@row > [task due today]@row, "Green", "Red")

If it is based on the current day:

=IF(TODAY() < [target date]@row, "Green", "Red")

Jen Castillo

Do you want it based on the current date, or is there a "task due today" column?

If there is a task due today column:

=IF([target date]@row > [task due today]@row, "Green", "Red")

If it is based on the current day:

=IF(TODAY() < [target date]@row, "Green", "Red")

QueryQuill

This worked! Thank you!