Count items in multi dropdown list
Hi everyone,
I am trying to count items individually from a multi-select column in a sheet called "Other Sheet" by adding the following formula to a separate sheet:
=COUNTIFS({Other Sheet}, CONTAINS("Value 1", {Other Sheet}))
It's not working, and I am getting "0" for all the items (which is not true).
Any ideas what's happening?
Thank you!
Best Answer
-
Hey @Magda
The range you need within the CONTAINS() function is the @cell. Since you have already given the range in the COUNTIFS() function, you now need to tell the CONTAINS() function (or the HAS() function if CONTAINS doesn't give you the expected result) to check each cell in that that COUNTIFS range.
=COUNTIFS({Other Sheet}, CONTAINS("Value 1", @cell))
If your value 1 is a number, do not enclose it in quotes. =COUNTIFS({Other Sheet}, CONTAINS(1234, @cell))
Does this work for you?
Kelly
Answers
-
Sorry, forgot to mention that the column in "Other Sheet" is a multi-select column
-
Hey @Magda
The range you need within the CONTAINS() function is the @cell. Since you have already given the range in the COUNTIFS() function, you now need to tell the CONTAINS() function (or the HAS() function if CONTAINS doesn't give you the expected result) to check each cell in that that COUNTIFS range.
=COUNTIFS({Other Sheet}, CONTAINS("Value 1", @cell))
If your value 1 is a number, do not enclose it in quotes. =COUNTIFS({Other Sheet}, CONTAINS(1234, @cell))
Does this work for you?
Kelly
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!