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

Find more posts tagged with

Accepted answers

All comments

Leibel S

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.

Leibel S

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()

Corentin Dal Farra

Hello @Leibel S

It works perfectly, thank you for the tip !

Have a great day,

Corentin

FuryFerrell

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.