Count for number of a specific tag



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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!