I would like to add a column that displays a number (e.g. “3”) based on the number of times a word (e.g. “YES”) appears in 5 specific columns of my base.
How would I do this?
1 Like
I have the same question, is this possible?
Check these:
@HammerOz , @Vernon_Fowler , @Karlstens –
I can get you halfway (the easy half) there, but using the inputs from a multi-select field as your keywords is problematic.
The easy part is this: The basic formula for counting the number of occurrences of {Word} in {String} is
(LEN({String}) - LEN(SUBSTITUTE({String},{Word},"")))/LEN({Word})
That is, you want to subtract the length of {String} with all instances of {Word} deleted. This provides you with the combined length of all instances of {Word} …
Hi Can anyone help please? I am trying to find a way to count linked records in the same table I think someone may have found a work around but am going around in circles trying to find anything I can understand.
Thanks, Maria
This is possible to do, although the process is a bit of a kludge.
The biggest problem is, as far as I know, there is no easy way to create a universal formula for counting collaborators; instead, you have to create a formula that explicitly counts a specific collaborator and either handle each collaborator in his/her own field, combine all of the formulas in one giant IF() statement, or figure out some other way to handle the data.
First, the formula. I assume you have a rollup or lookup fiel…
And others similar: Search results for 'count length' - Airtable Community Forum
1 Like