IF / AND formula help
I would like to add a condition to an IF formula that changes the health colour only when the Due date is not blank. Please can you assist?
At the moment the formula looks like this which works fine for tracking due dates:
=IF(Status@row = "Complete", "Green", IF([Due Date]@row = TODAY(), "Blue", IF([Due Date]@row < TODAY(), "Red", IF([Due Date]@row <= TODAY(+7), "Yellow", ""))))
However, if the due date does not have any dates in the column, the health colour turns to red. I want it to remain blank if no due date is entered but cannot think of the correct formula to achieve this.
Thanks for your help.
Help Article Resources
Check out the Formula Handbook template!