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

Answers

  • 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.

    School of Sheets (Smartsheet Partner)

    If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!