How to count items in a multi dropdown list?

Options

Hello -

I've read through plenty of scenarios on this topic but still haven't been able to get this to work exactly -

I would like to write a formula that counts the number of functions within the dependency column as a whole. Currently, I am using a COUNTIF function for each individual function but it does not work when there are multiple items in one cell (i.e. COUNTIF({Europe RemainCo. Workplan Range 4}, "Finance / Accounting") + COUNTIF({Europe RemainCo. Workplan Range 4}, "HR / Benefits"+.....etc.)

Any guidance on how to rewrite this formula to capture cells with more than one input would be greatly appreciated.

Thanks!

Naomi

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!