How to create a metadata sheet of associated metadata sheets?
I'm working on building a series of dashboards centered around individual projects, and I'd like to have a parent dashboard that rolls up all of the project data in one location. I've made the metadata sheets for the lower-level dashboards no problem, but I'm having trouble creating the overarching set. Here's the goals:
- From a project tracking sheet, count number of projects assigned to each employee of a certain status (accomplished using sumifs on the low-level metadata sheets)
- Capture total number of projects in each project status (accomplished using sumif on the lower-=level sheets)
I can roll up all of the data from the project sheets using reports, but is there a way to create a metadata sheet from that report to make more useful visuals in the parent dashboard?