Modify criteria for Schedule Health
I am trying to modify the criteria for the Schedule Health using the Project Management Office Template (https://app.smartsheet.com/b/publish?EQBCT=8c1ace8ce2d14472a986005d454626d8)
Currently it calculates the health based off of the actual and target start/end dates, however, I'd like for it to also factor in the % complete. For example, say a resource is "done" with their task, the status is complete and the dates align, however, the task is actually only 50% done. Based on the 50% completion, it should be yellow.
Additionally, I'd like to add blue for complete. I see how to add this in the column, but I'm unclear where to define this criteria to designate what each health status should mean.
Help Article Resources
Check out the Formula Handbook template!