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

edited 09/14/23 in Formulas and Functions


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!


Best Answer

  • Jen Castillo
    Jen Castillo ✭✭
    Answer ✓

    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")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!