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 wha…

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 th…

[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’…

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 numbe…

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	1009	December 16, 2020
Filter visibility by Character Count! Feature Requests	18	1883	January 23, 2022
Count number of Lines in cell Ask for Help	15	107	December 5, 2024
All New Data Editor & Computed Columns General	94	3043	November 19, 2021
How to split one AI prompt output (JSON) into multiple columns in Glide? Ask for Help	9	153	September 23, 2025

Words per sentence

Related topics