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
Mar 30, 2022
I have a table where I have lots of columns, but two in particular:
Primary column = article title (text)
secondary column = hyperlinked articles (multi-select)
The hyperlinked articles are a multi-select built with the list of all available article titles.
My question is: I want to add another column that counts the number of times “Article A” appears in all the multi-select arrays.
And repeat this calculation for every row, Article B, Article C, etc.
How do I do this?
Apr 05, 2022
Hi @Josh_Gladstone and welcome to the community!
You could change the multiple select field to a linked record field and add a count field in the newly created table.