I have a big sheet (called "Test")that have a lot of tasks that have the same type and number of subtasks. All subtasks have an "assigned to" column (contact list) and all subtasks are among three typs: not started, in progress or complete. I created a separate sheet (called Test.metrics) that roll up all "assigned to" info and "status" info for all subtasks, and plan to use that to build a dashboard -- how many tasks are assigned to different owners and how many % of subtasks are at different status etc. I know we can use COUNTIF in the metrics page to pull data from Test, but encountered issues when trying to pull data from the "assigned to" column or "status" column since they are across different subtasks.
Any suggestions are welcome!