How to create a dashboard using data from multiple "task trackers"

Dave H.

Each of the projects managed by my group have a task tracker with uniform standard tasks as the backbone of the project life cycle. What would be the best way to roll all of these individual sheets, which each reside in different project folders in the same workspace, and display them in a graphical format for quick review by leadership? Each of the sheets are generated from the same template. Also, should we use a naming convention/move them all into a task tracking folder?

Matt Lynn-PCG

@Dave H. If you have them coming from the same template then they'd have the same columns; this makes it perfect for 1 report. You could then group it by sheet name or some other helper column on each sheet like PM name or Project Name etc. Then put that on the dashboard as a report but you can also possibly create other similar reports with summaries and drive charts etc.

Humashankar

Very informative!