I have a dropdown list with multiple service items in text format, and I'm trying to count those text items. Seems easy but Countifs keeps giving me an error and I canot figure out why.

I have a separate metric sheet that includes the services I'm trying to count. Here is the formula

=COUNTIF({Survey Range 12}, CONTAINS([Services]@row))


  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    edited 06/07/24

    =COUNTIF({Survey Range 12}, CONTAINS(@cell,Services@row),{Survey Range 12})

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

  • JamesB
    JamesB ✭✭✭✭✭✭

    @SALLY P You need to complete the arguments for the Contains Formula.

    I am assuming that Survey Range 12 is your multi select column on the referenced sheet. That being the case the below formula says count the items in {Survey Range 12" where "What to Search for" is in {Survey Range 12}. I hope this make sense.

    =COUNTIF({Survey Range 12}, CONTAINS("What To Search for",{Survey Range 12}))

  • Matthew R
    Matthew R ✭✭✭✭

    I was able to get this formula below to work, unsure if it is exactly what you are after though.

    I used a HAS function instead of CONTAINS, and it would require to input the "Survey Item" manually in the quotations for each row.

    Hope this helps a bit!

    =COUNTIFS({Survey Range 12}, HAS(@cell, "Apple"))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!