Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
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?