I want to count the numbers of words in successive sentences of a paragraph. If one cell contains the whole paragraph, it’s easy to split it into sentences, making a cell with multiple values, each value being one sentence. Then I’m stuck. A roll-up column will count the number of sentences, but what I want is the number of words per sentence. Can Glide do that or do I have to write a bit of code?

No, just use the enter key. So it will look something like this: [Screen Shot 2022-03-26 at 6.16.00 PM]

Ya…It’s not super elegant. You’d need to define what a “sentence” is…perhaps a template column first to replace all ending punctuation with a || or something and then split column with || being the delimiter. [CleanShot 2022-01-31 at 10.16.24@2x] [CleanShot 2022-01-31 at 10.16.36@2x]

Yes, it was a no-code route I was looking for (otherwise, why not just use Python?). That’s very impressive, thank you. I’ll follow it through carefully. Good viideo!

Thank ou. Very impressive, I hadn’t thought at all of that approach. I replicated it and it all worked beautifully, except that I didn’t understand how you make the initial set up. At 0:49 there’s only one row, and then by 0:50 there are loads of rows and the first row of column 1 is repeated all the way down. How did you do that? And the same with the rowNumber column; it’s a <> column, which seems to mean a code column, but I can’t find anything that generates the row number. In the video you appear to be pressing New Row repeatedly and the next row appears with the row number and the start text just appearing automatically. Everything else makes sense, except for bringing in the users: is that so that each user can do their own analysis? I hadn’t looked that far ahead. BTW about sentences: if you split on ‘period followed by space’ you presumably have a problem with sentences that end a paragraph and are immediately followed by return. Of course, you’re right about periods marking abbreviations like ‘Mr’, not to mention the other marks that you also mention. And then there are ellipses marked as three dots ‘…’. Nothing about language is easy!

[image] got10thumbs: At 0:49 there’s only one row, and then by 0:50 there are loads of rows and the first row of column 1 is repeated all the way down. How did you do that? Start with a RowID column Add a Lookup column, that targets the RowID column. This will give you an array of all RowID’s Add a Find Element Index column, that searches for the RowID in the Lookup column. You should get an auto-incrementing number, beginning at zero.

That’s very ingenious. Thanks Darren! I would never have invented that.

We didn’t invent it either…it was featured as a reply to a recent post of mine: [image] RowID is great. Could REALLY use Row Number Feature Requests Yes, this can be added in Google Sheets…would rather have a native solution. Just a simple 1 through X where X is the number of rows in the table. This would work REALLY well with the Single Value column.

yeah, this one is a bit of game changer. It’s been less than a week and I’ve already found several uses for it. All kudos to @11183 - a really simple and elegant solution :+1:

Okay, does anybody know how to change username here?) I’m becoming famous))

Speaking seriuosly, i was thinking a lot about this problem, even though i personally don’t need it in my apps. That was just kind of an interesting challenge.

It’s incredibly useful when used in combination with the array-transpose method.

Words per sentence

Ask for Help

Robert_Petitto February 1, 2022, 12:49pm 26

We didn’t invent it either…it was featured as a reply to a recent post of mine:

Topic		Replies	Views
Counting words on Glide table! Ask for Help	7	1057	December 16, 2020
Filter visibility by Character Count! Feature Requests	18	1973	January 23, 2022
Count number of Lines in cell Ask for Help	14	216	November 28, 2024
All New Data Editor & Computed Columns General	93	3516	November 19, 2021
How to split one AI prompt output (JSON) into multiple columns in Glide? Ask for Help	9	210	September 23, 2025

Words per sentence

Related topics