COUNTIF for "Dropdown (Multi Delect)"

Gerhard da Costa Pinto

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

Kimberly Loveless

You would just need to use the CONTAINS function within the COUNTIF formula.

Something like.....

=COUNTIF([NFB Category]:[NFB Category], CONTAINS("Improved Efficiency", @cell))

Kimberly Loveless

You would just need to use the CONTAINS function within the COUNTIF formula.

Something like.....

=COUNTIF([NFB Category]:[NFB Category], CONTAINS("Improved Efficiency", @cell))

Gerhard da Costa Pinto

https://community.smartsheet.com/discussion/comment/306952#Comment_306952

Hi @Kimberly Loveless

Thank you so much for your response, that did the trick!

All the best,

Gerhard

Kimberly Loveless

Glad I was able to help @Gerhard da Costa Pinto 😀