Count IF(s) Formula Help

Anthony DAmbrosio

I need help with a formula in Smartsheet. I'm trying to count occurrences of specific values in my Issue Type column, but I have Allow Multiple Values Per Cell enabled, which is causing issues with the COUNTIF/COUNTIFS formula.

For example, my expected results would be:

• Incorrect Product (6)
• Missing Parts (2)
• Defective Products (3)

Is there a formula that can count individual values within multi-select cells?

KarinR

@Anthony DAmbrosio

Try this:

=COUNTIF([Issue Type]:[Issue Type], CONTAINS("incorrect", @cell ))

Change "incorrect" to "missing" or "defective" for each separate type.