Formula to count total number of items selected in a column of multiselect fields
Hi, I have a column called Type, which I've set up as a multiselect drop down. I'm struggling with a formula to count all the items that have been selected. For example, they may have selected 4 responses on each row, but when I created the summary field to do the count on the column, it only gives me the number of rows (10), not the total of all the selected items on those 10 rows (40, assuming 4 selected items on each row in the column) I had done this: =COUNT([TopicType]:[TopicType]) which gave me the 10, but didn't count all the responses. Here is an example of the data in the column. I'd like to count ALL the Topics selected across all the rows in the column, and it's only counting rows. Make sense? Thanks!
Best Answers

I think you just need to switch your function from COUNT to COUNTM and it will work as intended.

Thanks David, that fixed it!
Answers

I think you just need to switch your function from COUNT to COUNTM and it will work as intended.

Thanks David, that fixed it!

i'm looking for something similar however, i'm "referring another shee"t for my multi select column. I tried =COUNTM({Type}) and it came back as impermissible.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.9K Get Help
 377 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!