Sheet summary for resources that I can track

Buster Davis

So with my projects, I have a Project Manager field on each sheet. With that I can create a chart/data showing by project lead, how many projects they have. But within those projects, there are sub tasks that have assignees that I want to track as well as to the number of projects they are working on.. Is there an easy way to do this with a summary sheet/formulas

Natalia

Are you trying to track the total tasks they have?

One way I track how many items each assigned person per project is by using separate metrics sheet to track all my formulas and display it on dashboard.

=countif(Name), @row)

If you want a count by project

=countifs(name column), @row, (project name column), "project name")

For summary sheets, You'd have to add a sheet summary formula to all the project sheets you'd want to include to get a total count.

Andrée Starå

Hi @Buster Davis

I hope you're well and safe!

To add to Natalia's excellent advice/answer.

Have you explored using a Report instead?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Buster Davis

Do you have any thoughts on how a report can accomplish this item