COUNTIF for "Dropdown (Multi Delect)"
Hi all,
I'm hoping you might be able to help me. I'm putting together a Benefits tracker for my organisation's project portfolio, which aims to identify and categorise the Non-financial benefits (NFBs) that our projects will seek to realise.
One of the aims of this tracker is to be able to quantify how many projects are delivering each type of NFB Category (i.e., Improved Efficiency, Increased Staff Satisfaction, etc.).
For this purpose I have created a Dropdown (Multi Select) column that allows us to select the various NFBs categories that a given project will seek to deliver.
The trouble I'm having is counting these. I have set up separate analysis tool with a COUNTIF formula, with the range set as the Dropdown column mentioned above, and the individual category names as the criteria. Unfortunately, despite multiple occurrences of all categories in question, the formulae are returning zero.
I assume Smartsheet is unable to count data in this type of column, but wanted to ask if anyone knows a workaround that I could implement?
Many thanks in advance for your help on this matter, and I look forward to hearing from you!
Kind regards,
Gerhard
Best Answer
-
You would just need to use the CONTAINS function within the COUNTIF formula.
Something like.....
=COUNTIF([NFB Category]:[NFB Category], CONTAINS("Improved Efficiency", @cell))
Answers
-
You would just need to use the CONTAINS function within the COUNTIF formula.
Something like.....
=COUNTIF([NFB Category]:[NFB Category], CONTAINS("Improved Efficiency", @cell))
-
-
Glad I was able to help @Gerhard da Costa Pinto 😀
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!