Formula to Use in Multi Select Column
Hello!
I have a column that is set up as a multi select with four options in the drop down, and I would like tally of the total number of times each option was selected.
So for example, if my four options were Apples, Bananas, Peaches, Grapes, and people are able to select any or all of those options in a single cell, I would like a total of the number of times Apple was selected, a total for the number of times Banana was selected, etc.
I haven't had any luck with the formulas I have tried - does anyone have any suggestions?
Thanks so much!!
Answers
-
Try this for each,
=COUNTIF([Column Name]:[Column Name], HAS(@cell, "Apples"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 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
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!