1vote

How to check for word count in columns of Notion Database? Formula found here not working

I had used
if(length(Name) > 0, length(replaceAll(Name, “[^ ]”, “”)) + 1, 0)
provided by one of the kind folks here in 2021.

But it is not working. I am guessing this is is because Notion released Formula 2.0? Can someone please help me with the latest code for Formula 2.0?

1 Answer

1vote

thomas_yang Points3300

I'm not sure about your formula but this is the 1 I used previously.

length(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(prop("Name"), ",", ""), "\W", " "), "[ \t]+$", ""), "\s{1,}", "⨎"), "\w", ""))

Notion 2.0 shouldn't break existing formula since this require REGEX.

Template:
https://thomasyang.notion.site/Word-Count-76c4b258a70f41639effae83cf73a094?pvs=4

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect