Automatically assigning no symbol if finish date is blank
I am assigning Blue(Complete), Green(On Track), Yellow(Due in next 5 days), & Red (Over due) symbols to each task in a product plan in order to create a task status report. Becase I have the red symbol set as finish date in the past, all tasks with no finish date are showing up red. Can yuo help me with my formula below to add a function that will leave the symbols cell blank if the finish date is blank?
=IF([% Complete]56 = 1, "Blue", IF(Finish56 < TODAY(), "Red", IF(Finish56 <= TODAY() + 5, "Yellow", IF(Finish56 > TODAY(), "Green"))))
Help Article Resources
Check out the Formula Handbook template!