Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Wordcount formula?

Topic Labels: Formulas
Solved
Jump to Solution
974 1
cancel
Showing results for 
Search instead for 
Did you mean: 

How can I do a word count of a record?
I have a table to organize what I write divided by scenes and I want to count the words in every scene.
Thanks in advance.

1 Solution

Accepted Solutions

Hi @Ana_Capucho, I was looking into this as well today and found this page https://support.airtable.com/hc/en-us/articles/360035351893-Word-and-character-counts

They recommend using LEN({Text Field}) - LEN(SUBSTITUTE({Text Field}, ’ ', ‘’))+1

I’ve only started using it, but it has been working for me. Hope it’s what you’re looking for! :slightly_smiling_face:

Edit: I realized that it doesn’t return 0 for when there’s no text at all (instead it returns 1). So I got around that by modifying the above formula to return 0 when there is no text.

IF(({Text Field}=BLANK()),0,(LEN({Text?}) - LEN(SUBSTITUTE({Text Field},’ ', ‘’))+1))

See Solution in Thread

1 Reply 1

Hi @Ana_Capucho, I was looking into this as well today and found this page https://support.airtable.com/hc/en-us/articles/360035351893-Word-and-character-counts

They recommend using LEN({Text Field}) - LEN(SUBSTITUTE({Text Field}, ’ ', ‘’))+1

I’ve only started using it, but it has been working for me. Hope it’s what you’re looking for! :slightly_smiling_face:

Edit: I realized that it doesn’t return 0 for when there’s no text at all (instead it returns 1). So I got around that by modifying the above formula to return 0 when there is no text.

IF(({Text Field}=BLANK()),0,(LEN({Text?}) - LEN(SUBSTITUTE({Text Field},’ ', ‘’))+1))