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)
Help Article Resources
Check out the Formula Handbook template!