Formula question on a "Drop Down Multi-Selection" column type.



I am trying to count the amount of times a particular "ticket category" is selected. Some of our tickets have multiple values to be applied and I am noticing that my formula does not count an item if there was more than 1 selection in the column "ticket category" I have attached some images and my formula is as follows:

=COUNTIF([Ticket Category]1:[Ticket Category]29, "Paint")

So to reiterate, how do I make sure that the count catches multiple values a cell in "ticket category" and adds it properly to the overall count for those subcategories?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!