COUNTIFS for single-select and multi-select columns



I am trying to count the number of rows in a different sheet if they meet two conditions. One condition is contained in a Single-select column, the second argument is contained in a multiselect column in that sheet. I have looked through the community pages but have not been able to get a formula going:

=COUNTIFS({Different Sheet Range 2}, "Action", HAS({Different Sheet Range 1}, ColumnThisSheet@row))

Above the first range and criteria points to the single-select column, the second range to the multi-select column in a different sheet.

Any help is appreciated,

Thank you,


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!