Word Count in smartsheet?

edited 12/09/19 in Formulas and Functions

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?


  • 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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!