Milestones Completion Percentage

[chriseverclear]

Hi Experts,


I need assistance with one of my spreadsheet. Basically, if you open up project milestones tracking, you will see two tabs. One of the tabs is the master sheet and the other one is the project overview. If you look at the percentage, it says 50% completed. It is not correct since all the milestones are completed. It should say 100%. For example, if i have 4 milestones and if i completed 1, it should say 25%.

If you look at the second spreadsheet Office Template, i copied the formula from the Office free template.

Also, if you look at he project overview tab, you will see all the projects that i am working on. In the status column, i would like to show the percentage competion. Basically, if master sheet is 75%, it should also be 75% in the project overview status column.

Thank you!

[katiespirations]

hi,

your formula is fine, just you have 4 rows hidden with some notes and the formula counts them as well, just remove them from this table - tasks8 or change size of the table

kasia

[chriseverclear]

It works! Thank you so much.