Word Count in smartsheet?

MLT

I have a column in my sheet that contains a list of names of people that are attached to that record/row. I would like to add another column that displays the number of words in that column - just a count of people attached. So if the first column says "Jane, Jack, Jay", I'd like the second column to say "3".

 

I can't figure out how to do this for the life of me. Any thoughts?

Shaine Greenwood

Hi MLT,

You'd have to build a formula that searches for a pattern in your list of names, as there isn't a "word count" feature or function.

To accomplish this, you'll need to separate your names out into different columns. You can then count the names across the range of columns with a COUNT function.