Sign in to join the conversation:
I have a smartsheet with a list of countries that I would like to total up the number of unique countries in the list? Basically eliminating the dups in the count.
For example:
US UKIRUSCACAUKAU
would equal 5 Total Countries
thanks!
Hi,
There is no Count Distinct function in Smartsheet. I found this, which maybe helpful - https://community.smartsheet.com/discussion/unique-numbers-column
Sean
Add a checkbox column and a row ID column, then put the following formula into the checkbox column:
=IF([Row ID]@row = MIN(COLLECT([Row ID]:[Row ID], Country:Country, Country@row)), 1)
This will check the box for each single entry along with only 1 entry for each duplicate. You can then use a COUNTIFS to count how many boxes are checked.
You case is very similar to another one we just worked on.
https://community.smartsheet.com/discussion/feedback-submitter-count
Paul, this works great. Thanks for posting!
Happy to help!
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Cant find this anywhere
