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 2 1

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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!