Count of record in multi-select. Is it possible?

[Josh_Gladstone]

Hey all!

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?

[Databaser]

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.