I have automatic color dots, how do I add the If status (Due Date) is complete, return gray?
=IF([Due Date]3 < TODAY(), "Red", IF([Due Date]3 = TODAY(), "Yellow", IF([Due Date]3 > TODAY(), "Green")))
currently using the above formula to automate color dots for task health, however when an item goes complete it stays as RED. I'd like it report out as a gray.
Help Article Resources
Check out the Formula Handbook template!