Counting items from a text/number field


I have some users where we set up a text field and they are pasting information from Excel into the field. The info is nicely formatted and appears to have carriage returns when I wrap the text, see below. I am wondering if there is a formula that would help me count the number of items in the cell.

Thank you

paul e. reeves, CBAP

Austin, Texas

Houghton Mifflin Harcourt

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!