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

749 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1

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.