Count Multi-Select Options
Hi Community,
I have a multi-select column where I need to count the number of values selected (just the total, not individually). Is there a formula to help with this?
Below is a screenshot of my cell (Rollover) and the outcome I'm looking for (Months Rollover).
Thank you as always!
~Jaime 😀
Best Answer
-
Hello @Jaime Ciabattoni
Would this work for you - =COUNTM([Multi Select Drop Down]@row)
The below is from LINK
COUNTM Function:-
Counts the number of elements in a multicontact or multiselect dropdown column cell or cell range. When you use this function, it returns the total number of elements it finds.
Answers
-
Hello @Jaime Ciabattoni
Would this work for you - =COUNTM([Multi Select Drop Down]@row)
The below is from LINK
COUNTM Function:-
Counts the number of elements in a multicontact or multiselect dropdown column cell or cell range. When you use this function, it returns the total number of elements it finds.
-
Yes! Thank you @Protonsponge!
-
Great, pleased you got something that worked for you.
I'm grateful for the opportunity to help you out,
Protonsponge
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!