Counting items from a text/number field

Paul Reeves
✭✭✭✭✭
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
Best Answers
-
Try something along the lines of
=LEN([Affected Packs]@row - LEN(SUBSTITUTE([Affected Packs]@row, CHAR(10), "")) + 1
-
That did the trick. Thank you very much.
BTW... it was great meeting you @ENGAGE.
Answers
-
Try something along the lines of
=LEN([Affected Packs]@row - LEN(SUBSTITUTE([Affected Packs]@row, CHAR(10), "")) + 1
-
That did the trick. Thank you very much.
BTW... it was great meeting you @ENGAGE.
-
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!