Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to count collaborators?

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

Question: I have a collaborator field with numerous collaborators per record, and I was hoping to add a field that would add up how many collaborators there are listed in that record. How would I do this?
Thank you!

1 Solution

Accepted Solutions

After kicking this around for a while, I discovered @Simon_Brown had posted a workaround a year ago:

IF( LEN(Collaborator) = 0, 0, LEN(CONCATENATE(",", Collaborator)) - LEN(SUBSTITUTE(Collaborator, ",", "")))

Only caveat is that none of your collaborator names can have an embedded comma. (I fiddled around some with ARRAYJOIN() in hopes of using an alternative separator character, but Airtable’s insistence on stringifying anything that’s not a text, number, or date field prevents that.) It’s ugly, but it seems to work pretty well on multi-selects, attachments, and any field allowing multiple values – with the comma caveat, as well.

See Solution in Thread

4 Replies 4

I have the same question here. Have you found a solution by now?

Regards

After kicking this around for a while, I discovered @Simon_Brown had posted a workaround a year ago:

IF( LEN(Collaborator) = 0, 0, LEN(CONCATENATE(",", Collaborator)) - LEN(SUBSTITUTE(Collaborator, ",", "")))

Only caveat is that none of your collaborator names can have an embedded comma. (I fiddled around some with ARRAYJOIN() in hopes of using an alternative separator character, but Airtable’s insistence on stringifying anything that’s not a text, number, or date field prevents that.) It’s ugly, but it seems to work pretty well on multi-selects, attachments, and any field allowing multiple values – with the comma caveat, as well.

Works like a charm! thanks for the help, would have never been able to solve myself :slightly_smiling_face:

Thanks for that, very useful!

I don’t get why COUNTALL() can’t do that job. Any second with Airtable frustrates me :frowning: