Total Site % Complete + health
I need the total site % Complete
Each milestone has % complete for the site project
What is the sample formula to calculate each milestone % complete columns to give the site Total % complete?
Let’s say, Milestone ABCDEF etc
I just want to SUM all the milestone % complete to give me the total project % complete
Then the Project Health column will average all health columns to give me the Project Health color
There colors are red, yellow, green and columns that have Grey color it will not count for the average.
Thank you very much
Help Article Resources
Check out the Formula Handbook template!