IF Function and Cells without Data
I am trying to set up an IF function to automatically set a status using the RYGB symbols and how far away the target completion date is. I have had some success with the following
=IF([Target Completion Date]1 <= TODAY(-1), "Red", IF([Target Completion Date]1 <= TODAY(5), "Yellow", IF([Target Completion Date]1 >= TODAY(6), "Green", "Blue")))
Where I am getting stuck now is that if the Target Completion Date has no data in it, it's automatically turning the status column to Red and not Blue.
Thank you in advance.
Help Article Resources
Check out the Formula Handbook template!