Need Help With Color Coded Health Formula
Hello, I need some help getting color coded health status boxes to work for showing the status of fabrication work in rows. I want to use red for when the FAB STATUS % COMPLETE column is NOT 100% within two weeks of the NEED ON SITE DATE column. Yellow for when FAB STATUS % COMPLETE column is NOT 100% within two weeks of the NEED ON SITE DATE column. And finally green for when FAB STATUS % COMPLETE is NOT 100% within six weeks OR MORE from the NEED ON SITE DATE. I also want it to override these rules and make it Green no matter what if FAB STATUS % COMPLETE is 100% complete. Below are the actual names of the columns to help with writing the formula.
NEED ON SITE DATE
Fab Status % Complete (Needs Real Numbers)
Health Status For Fab Completion
"Health status for fab completion" is the Column where I am inputting the formula. I have it set to symbols with red, green, and yellow.
Thanks in advance to anyone that can help!
Help Article Resources
Check out the Formula Handbook template!