Countm Distinct formula for multiple dropdown column
When I use the countm(distinct()) formula, I get an answer of 4 instead of 3. This is a drop-down list with the option of having multiple values per cell. There are no extra spaces in my cells. The formula seems to know that there are 3 different options in the blue highlighted cell but is unable to see that the "K-S-212" in each cell is the same. How can I go about fixing this?
This question is similar to the one asked here: https://community.smartsheet.com/discussion/73516/count-distinct-formula-in-multiple-dropdown-column
Answers
-
You will need to create a helper multi-select dropdown column that has a JOIN formula (delimiter is CHAR(10) for line break) joining all cells together. This will filter out duplicates. From there you would use the COUNTM on the cell in the helper column.
-
Hi Paul
I am still getting 4 instead of 3.
-
Can you provide screenshots of your setup?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives