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.
Help Article Resources
Check out the Formula Handbook template!