Change Symbol based on date / clear if blank

Jerry Alexander
Jerry Alexander ✭✭✭✭
edited 12/27/22 in Formulas and Functions

I'm wanting the symbol to change based on the date field.

If date is today (or in the past), Red

If date is tomorrow, turn Yellow

If date is past tomorrow (in the future), Green

If date is blank, Blank - No color/Symbol

This was working to some degree, and somehow I broke it.... :)

=IF([Scheduled End Date]@row <= TODAY(), "Red", IF([Scheduled End Date]@row <= TODAY(1), "Yellow", IF([Scheduled End Date]@row <> "", "Green")))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!