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

Count all occurrences of String in Columns

436 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello all, new to Airtable.

Trying to do something that would be pretty simple in sheets or excell.

I want to count the number of occurrences a string appears in a column. Say, equipment in inventory, and counting the number of times that gear appears in the table to compare the number used to the number in inventory.

In theory, I would love something like the “Count” column below. Where the name is the record, gear and quantity are referenced from another table.

Name | Count | Gear  | Quantity
item1| 2     | apple | 2
item2| 1     | orange| 1
item3| 2     | apple | 2

Any suggestions would be greatly appreciated!

1 Reply 1

Hey Ted, is something like this what you’re looking for?

Screenshot 2022-05-26 at 11.56.00 AM
Screenshot 2022-05-26 at 11.58.46 AM

I’ve also put it together here. To view the setup, duplicate the base by clicking the title of the base at the top of the screen, then the three horizontal dots on the right, and then the “Duplicate Base” button.

Apologies if I’ve misunderstood!