I have a number of project plans in different workspaces. Each project plan is built from a template and they all have the same sheet summary fields, 3 of which are Overall Health, Schedule Health, and Scope Health. These are "red, yellow, green" symbol fields.
Separately I have a project tracker which is populated by an intake form - and there are additional fields to capture information that the requestor isn't asked to provide.
I have a portfolio level dashboard which provides data on each project through widgets which pull from sheet summary reports sourced from each project plan, etc.
What I'd like to do is to have a chart widget on the dashboard to show projects by status (red, yellow, or green). I know there is no cross-sheet linking available to sheet summary fields - this would have been useful to reference the health sheet summary fields in each project to their corresponding row in the project tracker and build the chart metric off these fields in the project tracker sheet.
It also doesn't look like it's possible to create a chart metric off a grouped report.
Wonder if anyone has any suggestions?
