Counting Items as Singles in a Multi Select Drop Down Column

Anthony D'Ambrosio · 09/08/21

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.

Paul Newcome · 09/14/21

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

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

Paul Newcome · 09/09/21

You are going to want something like this...

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

Anthony D'Ambrosio · 09/09/21

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 · 09/09/21

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 · 09/13/21

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

Anthony D'Ambrosio · 09/14/21

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 · 09/14/21

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

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

Anthony D'Ambrosio · 09/15/21

@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 · 09/15/21

You would add another range/criteria set...

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

Counting Items as Singles in a Multi Select Drop Down Column

Best Answer

Answers

Help Article Resources

Categories