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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

  • Judith Campf
    Judith Campf ✭✭✭✭

    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.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • Judith Campf
    Judith Campf ✭✭✭✭

    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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com