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

How to count the amount of times a specific word appears on a Rollup

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

I’ve read several posts similar to this already, I but haven’t figured it out.

I’m trying to count how many times the word “Retouch” appears in this Rollup record.

Captura de pantalla 2019-09-09 a la(s) 23.16.46.png

1 Solution

Accepted Solutions

Here is one way to do it in a formula:

IF(LEN({Work Types})=0,0,LEN({Work Types})-LEN(SUBSTITUTE({Work Types},“Retouch”,“Retouc”)))

You are removing one character from the string for every appearance of “Retouch” and then counting the difference in length of strings.

However, in these situations I prefer to identify the value in the other table. So I would have a formula in the other table you have rolled up from called “Retouched” that contains:

IF( {Work Type} = “Retouch”, 1, 0 )

You can then roll this field up in the table you posted above and just sum the values.

See Solution in Thread

3 Replies 3

Here is one way to do it in a formula:

IF(LEN({Work Types})=0,0,LEN({Work Types})-LEN(SUBSTITUTE({Work Types},“Retouch”,“Retouc”)))

You are removing one character from the string for every appearance of “Retouch” and then counting the difference in length of strings.

However, in these situations I prefer to identify the value in the other table. So I would have a formula in the other table you have rolled up from called “Retouched” that contains:

IF( {Work Type} = “Retouch”, 1, 0 )

You can then roll this field up in the table you posted above and just sum the values.

Thank you @David_Skinner , I feel so stupid having spent so much time trying to figure it out, when the solution was so obvious. It’s really cool having this community to support us noobs haha.!

@David_Skinner I’ve been going crazy trying to figure this out without COUNTIF - thank you for sharing! I know this is months after the original post, but I’m sure a lot of people are struggling with this exact situation.