Summarizing a Report by value count in a table


I created a report combining several different sheets, and I am trying to create (anywhere) a table that can count each topic from that combined report. Id like the table to keep updating as new topics are added.

For example:

Respiratory System | 1

Endocrine Systems | 1

Behavioral Health | 5

Thank you!!


  • SoS | Dan Palenchar
    SoS | Dan Palenchar ✭✭✭✭✭✭

    You could create a chart off of the report and put this on a dashboard.

    If you want to get the sum total of topics from multiple sheets, I'd recommend a separate metrics sheet that uses cross-sheet COUNTIF formulas to sum the applicable items from each sheet into one total. You could pull this data into the report or more elegantly organize it on a dashboard.

    👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner

    If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome.

    PS - If you have a follow up response use @Dan Palenchar so I get notified of your reply!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!