Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Suggestion: The Metric Widget should count items in a column
For example, if I have a dropdown of all 50 states, I should be able to set up a widget to count the number of times Alaska was selected, simply by selecting that column and one of the selectable options. If 20 people have selected Alaska, it would read 20. When a 21st person selects Alaska, then that widget would read 21.
If this is accomplishable now, I don't know how it's done, and would appreciate some assistance.
Comments
-
Hi Tyler. I suggest adding a summary row to your data. And then use the following formula for gathering the number you want which you can then use as the range for your metric widget.
=countif([column name]:[column name], ="Alaska")
Just replace [column name] with the name of your column. Use brackets if your column name has spaces in it or ends with a number.
Then when you create the widget: use the cell that contains that formula as your reference. You need to gather the metric or data that you want to use in the sight first, then you can point to it.
https://help.smartsheet.com/articles/518558-widget-types-for-smartsheet-sights#metric
The countif formula I created above will give you the number of count in a column that Alaska appears. If users add to the form later, it will continue to count the entire range.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives