IF for dates and text


I am trying to turn a symbol a certain color based on the following

If the status column is complete, turn it blue and ignore all else. If the status column is anything but complete use the following

=IF(TODAY() - [End Date]@row > 0, "Red", IF(TODAY() - [End Date]@row > -3, "Yellow", "Green"))

The above works for validating against the end date column, I cannot figure out how to add the additional reference to status column if complete. Any help would be amazing before I lose ALL my hair.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!