Counting Items as Singles in a Multi Select Drop Down Column

Hello Smartsheets Community:

Does anyone have a simple solution to count items as individuals when using a Multi Select Drop Down Column.

In the screen shot below, we have a column where we put the potential customers we think we are going to sell a new product. What I would like to do is be able to accurately reflect total number of customers.

For example:

Amazon 2

Lowe's 2

THD 2

Lowes.com 2

THD.com 1

Any suggestions would be welcomed. I tried COUNTIFS, COUNTIF and I could not get it to work.

Find more posts tagged with

Accepted answers

Paul Newcome

Try this EXACTLY (copy/paste if needed)...

=COUNTIFS({Potential Customers}, HAS(@cell, Label@row))

All comments

Paul Newcome

You are going to want something like this...

=COUNTIFS([Potential Customers]:[Potential Customers], HAS(@cell, "Lowe's"))

Anthony D'Ambrosio

When I fill out the suggested formula, when I get to the step of referencing the @cell. As soon as I enter "Amazon" the @cell highlights itself and when I complete the formula, I get #UNPARASABLE. See screen shots below.

Paul Newcome

Use "@cell" exactly how I have it in my example formula. If you want to use a cell reference to tell it what to pull on then it would look like this...

HAS(@cell, Label@row)

Anthony D'Ambrosio

I tried your suggestion and I am still getting the #UNPARSEABLE error. I'm sure it's user error with the way I wrote the formula. Did I write the formula correctly?

Smartsheets Formula Issue.JPG

Thanks for all your help and suggestions.

Anthony D'Ambrosio

https://community.smartsheet.com/discussion/comment/304504#Comment_304504

Paul I tried your suggestion and I am still getting the #UNPARSEABLE error. I'm sure it's user error with the way I wrote the formula :). What am I doing incorrectly?

Smartsheets Formula Issue.JPG

Thanks for all your help and suggestions.

Paul Newcome

Try this EXACTLY (copy/paste if needed)...

=COUNTIFS({Potential Customers}, HAS(@cell, Label@row))

Anthony D'Ambrosio

@Paul Newcome thank you very much for your help and patience while walking me through this formula. What you provide worked! One last question if you do not mind. How might I apply that same formula to count up the individual customers in a multi-select column by Project Category Type?

For example, in the screen shot below. What if we want to count up all the individual customers on our intake sheet that are assigned to ECOMM (highlighted in yellow)?

Again, I cannot thank you enough for all the help!

Paul Newcome

You would add another range/criteria set...

=COUNTIFS({Potential Customers}, HAS(@cell, Label@row), {Category Type}, @cell = "ECOMM")

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.