counting multiple select column


I have a project plan that I'm trying to report on. I have a column for health check and a column for assigned team.

I want to see a total count of each status per team. That is the easy part and I figured that out by doing a

=COUNTIFS({HealthCheck}, "Red", {Team}, OR(@cell = "FI", @cell = "FIT"))

My issue is that it will only count if there is one team in the team column. If I have multiple teams such as FI, FIT the formula above won't count it.

How do I tell the formula to count if a value appears anywhere in a cell not exactly equal to that cell?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!