Multi-Select Columns and Counting Occurrences

Options
Amy Evans
Amy Evans ✭✭
edited 09/13/23 in Formulas and Functions

UPDATE:

Solved it....

=COUNTIFS({Category Lifecycle}, CONTAINS(Category@row, @cell))

Please ignore below.


Hello,

I have a column with multi-selects. I want to be able to count the occurrences of each selection.

My formula only counts the selections when they are by themselves. When a selection is part of a multi-select, the formula doesn't acknowledge it.

=COUNTIFS(Options:Options, [Total Selections]@row)

The correct answer for total count of "Option 1" should be "3." There are 3 occurrences of Option 1.



Thanks,


Amy

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!