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?
Answers
-
For your #2, I'd run your projects down the left on your metrics sheet (where your names are now) and run your names across the top (the gray row). And create index/match cross sheet references to pull your numbers.
Then you can sum those at the bottom to get your #1.
For your #3, if you're looking for the low level detail, I'd created a report that connects to your projects and filter by team member (this only works if you DON'T have your team members in a multi select column). Then Save As New this report for each team member. Then you can display these reports on your dashboard.
Is that what you were looking to do?
-
Hi Ryan,
Sounds like this will work! thank you I'll be working on that today. see how it goes.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!