W_Vann_Hall:
IF( LEN(Collaborator) = 0, 0, LEN(CONCATENATE(",", Collaborator)) - LEN(SUBSTITUTE(Collaborator, “,”, “”)))
Thanks for that, very useful!
I don’t get why COUNTALL() can’t do that job. Any second with Airtable frustrates me :frown...
The more I search about how to do something with Airtable the worrier I get that this is not the right tool for me.
In a logical sense, it should be possible to amend a field based on another one. Not only for display purpose (thanks for the workarou...
I’ve been impressed with Airtable functionality and seen it as an amazing replacement of our Google Sheet approach with potential to run our business end-to-end.
Unfortunately without the ability to check data from another base the tool isn’t fit for...
