How would I write a formula to automatically populate a status column with red, yellow, or green based on where the project is at? In the screen shot below the Implement Asset Works is on-track because the gantt bar is filled in to the dotted line. The Implement Salesforce is behind schedule since the gantt bar is only partially filled in.
What I would like to do is have the Status be green if the project is on-track or less than 1 week behind. If the project is between 1-3 weeks behind then yellow. If the project is more than 3 weeks behind then red. Thoughts on how to accomplish this?