Count Distinct formula in multiple dropdown column
Hello everyone
Do you know how I can use count distinct formula to a column that have multiple value dropdown list ? I think that it works only if I have one value per cell, but If I get multiple values for a cell then the count distinct formula do not work anymore.
I have the same question for a count distinct formula about multiple contact list column.
Thank you for your help, have a nice day,
Corentin
Answers
-
Corentin,
Run the below formula (changing the column name to match yours) in another Multi Select column. This will pull every unique value:
=JOIN([Column3]:[Column3], CHAR(10))
You can then run =COUNTM() on the cell where you put the previous formula.
-
Contact columns will require a bit more. Those are separated by "," not a char(10).
You would need to convert the contact column into a multi select column. Create a Multi Select column and your formula should be:
=SUBSTITUTE(CONTACT@row, ",", CHAR(10))
Then run the previous formulas on this column:
=JOIN([contactmulti]:[contactmulti], CHAR(10))
=COUNTM()
-
-
When I use the countm(distinct()) formula, I get an answer of 4 instead of 3. There are no extra spaces in my cells. The formula is unable to see that the "K-S-212" in each cell is the same. How can I go about fixing this?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives