Count for number of a specific tag
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!
Answers
-
Are you able to provide a screenshot of the source data for context/reference?
-
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).
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.
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!