% 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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!