Combining Data from Multiple Sheets

Nasir@EBC

Hi All

I am having 8 different project-sheets and each project has some common tasks (like "Design Status").

Now I want to be able to count the Design Status from all the projects whose value is "ready", and after counting I want to display this count on the dashboard so that I know how all my projects are progressing.

Please help!

Thanks

Nasir

Andrée Starå

Hi Nasir,

There are a few different ways to structure it. Here are a few suggestions.

• Create a Master Metric sheet and use cross-sheet formulas to calculate everything together.
• Same as above with the calculations done on each sheet and then cell-linked to the Metric sheet.

What do you think?

Would that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

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