is there a wordcount formula?
I have a cell where I need to know how many words there are.
Best Answer

Check the length of the sting, remove all the spaces, check again, the difference + 1 is the word count.
=IF(text@row <> "", LEN(text@row)  LEN(SUBSTITUTE(text@row, " ", "")) + 1, 0)
Answers

Check the length of the sting, remove all the spaces, check again, the difference + 1 is the word count.
=IF(text@row <> "", LEN(text@row)  LEN(SUBSTITUTE(text@row, " ", "")) + 1, 0)
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!