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!
Greetings- I have a drop-down column where a staff member is emailed (request an update) if a row is marked as "assigned". If row 1,2,3 are assigned to the same staff member within a few mins, that staff member receives 1 email rather than 3 separate emails. We want each row to be a separate email so they can mark that row…
All of the automation workflows on all our sheets are "missing". This is what we see when we click "manage automation workflows" We're also unable to create new workflow. Smartsheet Gov Status shows no issues with workflows. Is anyone else experiencing this issue?
Hi. I have been the System Admin for the past 2 years. When I came into this role, I added our logo under the setting in Branding & Personalization. Our logo has now changed and I need to update it. However, when I go to Branding & Personalization the only options I have are Profile Visibility and Working Days. Did…
