RYGG based on dates and complete check box with blanks
I have had success with most of this equation, the part that is stumping me is that I want to have the health status turn "Gray" if there is no "Finish" date to indicate that it has not yet been started/not yet being worked on. I have the other colors to be set to work respectively with the "Finish" date and the "Complete" yes/no and they seem to be working the way I want them but I cannot get the gray to work when there is no date/that cell is blank. Anyone willing to help? Thank you!
=IF(AND(Complete4 = 0, Finish4 <= TODAY(-2)), "Red", IF(AND(Finish4 > TODAY(-10), Complete4 = 0), "Yellow", IF(AND(Finish4 > TODAY(-5), Complete4 = 1), "Green", IF(AND(Finish4 = " ", Complete4 = 0, "Gray")))))
Help Article Resources
Check out the Formula Handbook template!