% Complete Across Multiple Project Plans

Dear Community,

I have 7 Project Plan sheets. All of them report a total %Complete for each Project Plan. I would like to add up the %Complete then divide by 7, for an overall %complete across all sheets. (I'm assuming I'd add all the %complete and then divide by 7 - though that may not be mathematically correct, either)

Any thoughts on how to get this done? I've tried to create a new sheet, link that information for each 7 sheets, and then add them up, etc. However, you cannot create a formula for a value that has been linked in.

thanks for your help!

Much appreciated!

Lynda

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!