Can I calculate % complete & % remaining from multiple project plans into master dashboard?
I need to calculate % complete and % remaining from multiple sheets into one master dashboard. I have 4 separate project plan sheets that have these percentages for the individual project sheet, but want to see the overall percentages complete/remaining for the 4 sheets as they are all part of one major project. I appreciate any assistance you can offer/suggest. Thanks.
Help Article Resources
Check out the Formula Handbook template!