Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Count Field Improvements - Count Collaborator Field

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Karlstens
11 - Venus
11 - Venus
Status: New Ideas
What is the proposed idea/solution?

The Count Field is unable to Count the collaborator field. To return a count (length) of users from the Collaborator field, Base administrators are forced to employ a Formula that is not ideal.

How does is solve the user problems?

A base administrator can add a count field to count their users within a Collaboration field without having to Google Search why it's not possible, only to find a formula hack is needed.

Who is the target audience?

Everyone who expects the Count Field to be useful with counting various other elements that are found within the many other Airtable Field types - such as, but not limited to, the User collaboration field.

1 Comment
DamienVM
4 - Data Explorer
4 - Data Explorer

@W_Vann_Hall Found a solution here is the thread :


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.