Count # of values in a Multi-Select Cell

Options
MCorbin
MCorbin Overachievers Alumni
edited 12/09/19 in Formulas and Functions

I have a multi-select column in my sheet, and I'm trying to count how many items are actually selected in each cell.   Is there a way to do that?   I've seen a post that suggested creating a "helper column", but can't figure out the formula that would actually do the count.

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!