Word Count Function in Formula Field
T
Thomas Buck
I need to create a 95-100 word description for a product, but SmartSuite doesn't have a built-in word count function. It would be beneficial to have a formula that can count words in a text cell, similar to what other tools like Coda, Airtable, and Notion offer. This feature would help me ensure my product descriptions meet specific word count requirements without manually counting words.
J
Jeff Eusebio
You can get pretty close with something like this:
IF(
IS_NOT_NULL([Product Description]),
LENGTH(TRIM([Product Description])) - LENGTH(REPLACE(TRIM([Product Description]), " ", "")) + 1,
0
)
K
Kenneth Rea
While your request is going through the process, have you considered something like a 400 character limit on a Text Area field?