1 Symbol is not updating with fomula

I am using the RGB balls for tracking tasks. I have red set to activate if the date in the finish column is in the past.

The other 3 color denote status of the task.

Formula: =IF(Status3 = "Not Started", "Gray", IF(Status3 = "In Progress", "Yellow", IF(Status3 = "Complete", "Green", IF(Finish3 < TODAY(), "Red"))))

GRAY, Yellow, and Green all work on the row, just the Red one is not working.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!