Multi-Select Not Counting As Expected for Dashboard
I want a count of each time an answer is selected from a multi-select question. The countif is only counting 1 if an answer shows up once, but not counting when an answer appears more than once.
Formula I'm using is: =COUNTIF({Student Satisfaction Survey Range 5}, "More live lessons") to find all the instances of "More live lessons".
The first image is how the results are showing in my data collection. The second image is the actual survey results.
Best Answers
-
Try this...
=COUNTIFS({Student Satisfaction Survey Range 5}, CONTAINS("More live lessons", @cell))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Happy to help. 👍️
The parenthesis are color coded to help you track where each statement is opened and closed. This helps when you are nesting a lot of different functions or need to make sure that your argument sets are correct.
The colored parenthesis are there as a helpful tool. Not a warning.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Continuing with my thread, if I use the formula
=COUNTM({Student Satisfaction Survey Range 5}, "More live lessons")
I get the total number of items in that column rather than only the count of "More live lessons".
I want the result to show 3 as the number of times "More live lessons" was selected.
-
Try this...
=COUNTIFS({Student Satisfaction Survey Range 5}, CONTAINS("More live lessons", @cell))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
That did the trick, @Paul Newcome . Thank you so much.
Have to say that I tried that but saw pink parentheses and thought I was doing something wrong with the formula so I kept removing the pink parentheses, or adding more parentheses, to see if I could get rid of them. Glad to know that they were needed and that it works.
Appreciate the assistance.
Judy
-
Happy to help. 👍️
The parenthesis are color coded to help you track where each statement is opened and closed. This helps when you are nesting a lot of different functions or need to make sure that your argument sets are correct.
The colored parenthesis are there as a helpful tool. Not a warning.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives