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
-
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")))
Answers
-
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")))
-
Thank you, I was missing a quotation mark and kept getting errors. Yours fixed it!!
Help Article Resources
Categories
Check out the Formula Handbook template!