Countifs in a Column Properties with Multi Select
I have a sheet collecting best times available for each of the 10 courses available, the multi select drop down is:
Monday Morning (7a-12p)
Monday Mid-Day (12p-4p)
Monday Evening (4p-9p)
Tuesday Morning (7a-12p)
Tuesday Mid-Day (12p-4p)
Tuesday Evening (4p-9p)
Wednesday Morning (7a-12p)
Wednesday Mid-Day (12p-4p)
Wednesday Evening (4p-9p)
I need to count how many of each is selected.
I set up second sheet as a metric to count, however when using the formula =COUNTIFS({Student Preferences210}, [Day of the Week & Time]@row) it only counts if one instance is in the cell. It does not count if there are multiple dates times selected.
Sheet that is collecting Student Preferences:
Metric Sheet that is counting the selections: =COUNTIFS({Student Preferences210}, [Day of the Week & Time]@row)
What is the best formula to count each Day of the Week & time that is selected in a mulit select?
Best Answer
-
Hi @Charlene Stacy and @whitemd1964
When you're searching for a value in a multi-select field, you can use the HAS function to specify that you're looking to see if the cell has that value, like so:
=COUNTIFS({Student Preferences210}, HAS(@cell, [Day of the Week & Time]@row))
See: HAS Function
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
I am hitting the same issue. did you get a response yet?
-
Hi @Charlene Stacy and @whitemd1964
When you're searching for a value in a multi-select field, you can use the HAS function to specify that you're looking to see if the cell has that value, like so:
=COUNTIFS({Student Preferences210}, HAS(@cell, [Day of the Week & Time]@row))
See: HAS Function
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
The solution =COUNTIFS({Student Preferences210}, HAS(@cell, [Day of the Week & Time]@row)) works perfectly, thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!