What formula do I use to count individual items in a multi-select dropdown cell?
I am trying to count individual items within a multi-select cell so that I can reflect the data in a chart in a Dashboard.
For example: If I want to find out how many people chose "Travel --- Reimbursement" in a multi-select field, how do I count just the "Travel --- Reimbursement" if various cells have other items in it (i.e. Travel --- Reimbursement, P-Card Payment, and Admin Tasks).
Any suggestions would be greatly appreciated!
Thanks!
Karen
Best Answer
-
Try something like this...
=COUNTIFS([Multi-Select Column]:[Multi-Select Column], CONTAINS("Travel --- Reimbursement", @cell))
Answers
-
Try something like this...
=COUNTIFS([Multi-Select Column]:[Multi-Select Column], CONTAINS("Travel --- Reimbursement", @cell))
-
That totally did the job!! 😀 Thank you so much for your help!
-
Happy to help! 👍️
-
How do I count specific values from a multi select drop down on a different sheet? I have a data sheet to pull from for a dashboard and need to count how many times someone selects specific values and I want to know how many times each is selected. (Pricing/Budget, Complexity, Set of offerings/capabilities, Timing/Purchase Cycle, Outsourced IT Services, Other)
I've tried using =COUNTIF({ Rep Feedback Range 1}, CONTAINS("Pricing/Budget", {Sales Rep Feedback Range 1})) but the value says 0 instead of the actual amount.
-
@VictoriaBrowder Replace the second range with "@cell".
-
That was so easy! Thank you!!
-
-
Why is this formula =COUNTIFS([Multi-Select Column]:[Multi-Select Column], CONTAINS("Travel --- Reimbursement", @cell)) not working for me :(
-
@MANNA There could be any number of reasons. Are you getting an error message or an incorrect count?
-
yes i got 0 when it supposed to be 1
-
-
Hi @MANNA
I hope you're well and safe!
Try something like this.
=COUNTIFS([Test Category]:[Test Category], HAS(@cell, "a"))
Did that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. 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.
-
You will need to replace [Test Category]1 inside of the HAS function with @cell and then flip the order
HAS(@cell, "a")
-
omg it work!!! thank you!!
-
Excellent!
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. 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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!