Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

1194 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Josh_Gladstone
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.
image

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.