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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!