How to count projects on a report

JLuke
JLuke ✭✭✭
in Formulas and Functions

I have a report that summarizes all the projects assigned to my PMs.

image.png

How can I create a graph or metric that shows how many projects assigned to each PM?

· Share on FacebookShare on Twitter

Answers

  • Jason P
    Jason P ✭✭✭✭✭

    Hi @JLuke

    We have the same need, we achieved the counts using report Filters - Group & Summaries. When applied I then display this report on our Dashboard for Management. Would this work for you?

    Rpt Totals.JPG

    Cheers.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!