Count dropdown values
Good evening, I am looking for help on a formula. I am looking to reference another sheet and count how may times a value appears in a drop-down multi-list.
thanks in advance...
Best Answer
-
Hi @ScottPinson_AlliedSolutions
Try using the HAS function within @Andrée Starå's formula... like this:
=COUNTIF({Source}, HAS(@cell, "Red"))
The HAS function is built specifically for multi-select drop-down lists, and will check to see which cells have that criteria, whether or not there are other selections in the cell as well.
Let us know if this works for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @ScottPinson_AlliedSolutions
Try something like this.
=COUNTIF({Source}; "Value")
Did that work?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks for the post Andree, I tried that but that only counts the cells that are equal to the value not the ones that contain the value. For example, if the dropdown contains 4 values (Red, Blue, Green, Black) and I use =Countif({Source},"Red") it will not count that cell).
Thanks
Scott
-
Hi @ScottPinson_AlliedSolutions
Try using the HAS function within @Andrée Starå's formula... like this:
=COUNTIF({Source}, HAS(@cell, "Red"))
The HAS function is built specifically for multi-select drop-down lists, and will check to see which cells have that criteria, whether or not there are other selections in the cell as well.
Let us know if this works for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Happy to help!
I saw that Genevieve answered already!
Let me know if I can help with anything else!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Genevieve, thank you. That worked, I ended up using contains formula but same result.
=COUNTIF({Project ID2}, CONTAINS(Label@row, @cell))
Thanks for the responses.
Great community support!
-
Hi @ScottPinson_AlliedSolutions
Glad you figured something out!
Keep in mind that CONTAINS will find partial matches... so if your content in the Label column has "App" and another row has "Apple", then CONTAINS will see "Apple" as a match for "App" since it contains those letters. (Versus HAS, which looks for exact matches.)
If all your values in the Label column are unique and not found within other values then Contains will work just fine.
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!