How to find 2 values from a multi-select column for reporting


I am trying to count how many times in a smartsheet 2 values show up in a multi-select column. example: i have a multi-select column with multiple options and I want to count how many times "Drainage" and "Roadway" are both selected. This can be done with the filter in the grid using the "has all of" options. This is the formula I have currently.

=COUNTIF([Discipline In Court]:[Discipline In Court], FIND("Drainage/ Roadway", @cell) > 0)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!