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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!