Summarizing multiple multi-select columns


Good morning,

I have 5 project managers using the same template of a sheet to track their current ongoing projects in one spot. One of the columns is a multi-select where they must choose all the suitable categories that the project are covering.

Is there any way in my report to summarize how many of each category option have been selected across all of the project manager's selections? For instance, Option 1 has been selected 26 times across the 5 Project manager sheets.

Anybody have any ideas? The closest thing I've managed to find is using a COUNTIF equation and trying to use "find" for the wording, but even that has not brought back accurate results.

=COUNTIFS({Category Column of PM}, FIND("Option 1") > 0)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!