Counting number of tasks per Assigned To contact as well as by project
I have 24 projects, the same team is working on any number of tasks in each of these projects. I want to see the following:
1) Task count per assigned to
2) Task count per assigned to and by project
3) status of each task that each team members has
So far I have Created columns on each project sheet with column headers showing statuses and their task count pulled from the data. I'm not sure how to combine this so that I can pull the above metrics on a dashboard.
And I have this sheet where I want to pull everything together.
but is it better to just pull the information from each project sheet into my dashboard?
Help Article Resources
Check out the Formula Handbook template!