Creating a column that counts the average completion of projects based on milestone
I am trying to write a function that helps me calculate the total percentage completion of each project based on milestones
I have 2 columns
1- Classification / it has project, milestone, activity category
2- % completion / it has the percentage completion of each category above project/milestone/activity
Is there a way to obtain the total % completion for each project based on the percentage of each milestone and the total milestone % completion based on each activity in a separate column?
Help Article Resources
Check out the Formula Handbook template!