IF for dates and text

Debbi3401

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.

Sameer Karkhanis

You just have to nest the condition like below,

=IF(Status@row = "Complete", "Blue", IF([End Date]@row < TODAY(), "Red", IF([End Date]@row - TODAY() < 3, "Yellow", "Green")))