Count for number of a specific tag

krstffr

Hello,

I'm new to smartsheet, so please forgive me if this question has been asked. I'm not sure what words to use to search for this type of functionality.

I have a smartsheet that tracks award wins and losses. I would like to be able to create a dashboard that tells me how many total wins and losses we have had across all the sheet rows.

The same sheet also tracks what the award was. For instance, Gold, Silver, Platinum, Merit, etc.

How do I create a counter that tells me how many gold, silver, platinum, etc wins are on the sheet that I can use for a dashboard?

Thank you!

Paul Newcome

Are you able to provide a screenshot of the source data for context/reference?

krstffr

Hi Paul, thanks for responding!

I've created a demo here that gives a basic gist for what I'm trying to accomplish. My actual sheet is much more complex (more than 200 entries).

https://app.smartsheet.com/b/publish?EQBCT=0bfec210b49e4c658875471c11a13aee

There are a few columns that I'm using for filtering:

• Filter by Year
• Filter by Award
• Filter by Award Status
• Filter by Award Designation
• Filter by Region

Right now, everything lives in one sheet. Ideally, I'd like to be able to create a report/dashboard that shows me that status of awards across the 5 columns. You'll notice that where there's a loss, there's no award designation in that column.

I hope that makes sense. Thanks in advance for any insights you can share.

Paul Newcome

I would suggest creating various reports based on your needs then using the report Grouping and Summary features to get your totals which could then be used to create a chart.