% Complete Across Multiple Project Plans

Lynda Ross

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

Andrée Starå

Hi @Lynda Ross

I hope you're well and safe!

Could you maybe use the new reporting features to average all projects?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!