Unique Values for a Metric Widget in a Dashboard
Good Morning,
I am trying to pull unique values (names) from a column, to see how many times those names appear and have that in a (Pie Chart?tbd). This is input from a form, so I'm trying to track engagement in the process via amount of entries per person. That being said, it may be better to track this along with the dates, and gauge the amount of entries done by each individual within a month for example? Please help!
Also, I'm trying to do the same thing with values from another column, but those are auto-populated with an Index/Match formula from another sheet.
Answers
-
I would create a report from the sheet and use the Count function to summarize based on the column with the names. Would that work for what you are trying to achieve?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!