Function to retrieve count in a multi-select column



So I have a multi-select column which upto 7 selections currently. What I am trying to do is have a bar chart of count based on the number of selections in each cell. To give an example.

row 1 : A, B, C,D,E,F,G

row 2: B,C,D,E

row 3: A,C,D

row 4: C,E,F

row 6: A

So what i would like to do is create a graph like

number of occurance with 7 values selected:

number of occurance with 6 values selected:

number of occurance with 5 values selected:


Hope that above was not cryptic. I have been trying some options with countifs but could not get it working yet.

Any help would be much appreciated.



Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!