COUNTIFS reference another sheet with multi-select dropdown and other criteria

I have built a sheet to count topics by referencing data on another sheet but have run into some hiccups where where a multi select dropdown is used.

I want to count the number of times a topic appears in a column where the criteria from two other columns are also specified.

{Type} is the sheet reference to a column with multi-select dropdown

=COUNTIFS({Type}, HAS(@cell, "Brand", {FQ} = "Q1", {FY} = "FY 2021"))

Everything about this formula works until I try to reference the multi-select dropdown column. What am I doing wrong here?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!