Need a formula for sheet summary field

Amy Blevins

I am trying to obtain a total number (that will change as more rows are added) for a column of names to create a sheet summary field for a widget on our dashboard to reference.

Mark Cronk

Hi @Amy Blevins ,

=COUNT(DISTINCT([Nike Requestor Name]:[Nike Requestor Name])) should work. @Nic Larsen had the right formula. Mine had a typo. Sorry.

Mark

Mark Cronk

Hi @Amy Blevins ,

If you just need a count of names in the column Names, the formula would be =Count([Names:][:Names])

Create a new summary sheet field and enter the formula. Then use the Metric widget on your dashboard to display the number. Navigate to your sheet and select the Sheet Summary Data radio button at the top of the dialog box. Select the summary sheet field you want displayed.

Work?

Mark

Amy Blevins

I thought I did it correctly, but it didn't work. I also have more clarification from my boss about what we are trying to capture. I am attaching a screenshot of what it looks like/what I am trying to do. I want the Nike Requestor Name column to be counted by unique users. So, not have a name be counted twice, but to understand how many people are using the forms.

Mark Cronk

Hi @Amy Blevins

Try:

=COUNT(DISTINCT([Nike Requestor Name:][:Nike Requestor Name]))

Info on the DISTINCT Function is at: https://help.smartsheet.com/function/distinct?_ga=2.187824877.471712069.1607197941-1121392143.1607197941

Work for you?

Mark

Nic Larsen

Try this: =COUNT(DISTINCT([Nike Requestor Name]:[Nike Requestor Name]))

Amy Blevins

It is still coming up as #unparseable ... do I need to select a cell in the column?

Mark Cronk

Hi @Amy Blevins ,

=COUNT(DISTINCT([Nike Requestor Name]:[Nike Requestor Name])) should work. @Nic Larsen had the right formula. Mine had a typo. Sorry.

Mark

Amy Blevins

Yay! It worked! I had to type it in, not just copy and paste. Thank you both so much!

Mark Cronk

Happy to help.

Mark

jcurry

Thank you all for your insight! I am interested in a similar formular, though I don't want to count a range, I would like to count cells with certain text. I haven't been able to figure out how to adapt the formula provided her to accomplish that. Thoughts?