Unique Values for a Metric Widget in a Dashboard

Options
MJones
MJones ✭✭✭
edited 05/26/22 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!