How to link the health column to show an accurate status of at risk tasks.
I am looking to find a way that I can link (create a formula) so the health column shows a traffic light system for the status of the task.
I want to aim for this to detect the percentage of completion of a task in relation to the finish date. For example, if the finish date is only a couple of days out and the task has not been started yet, the health would show as red. Alternatively if the task is showing as 100% complete and the finish date has not yet occurred the health would show as green.
Does anyone have any knowledge of how to write a formula for this as i am at a complete loss.
Help Article Resources
Check out the Formula Handbook template!