Sheet summary for resources that I can track


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
    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å
    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!


    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!


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

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Buster Davis

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!