Creating a chart from a multi-select dropdown among multiple sheets?
I am running into a roadblock on creating a report and graph for the below scenario.
We have a bunch of event sheets (about 10) that all have an 'assigned to' column that is a multi-select contact list and it varies between sometimes being assigned to just one person and sometimes to multiple. I am trying to create a graph that would show outstanding tasks (where complete is unchecked) for each of the contacts. In attempting to spin up a metric sheet, the COUUNTIF formula seems to only be available for a single sheet of data, not across multiple. Is there a clean way to do this? Or do I need to make a metric sheet with every sheet having its own countif formula and then adding those sums together?
If that is the case, any ideas on how to make a report where a manager can go in, see a report of each contact and what outstanding tasks they have spanning all 10 sheets?
Help Article Resources
Check out the Formula Handbook template!