Multi-part formula with multi select field using references issue


I am trying to write a formula that includes sheet references, and two conditions. I need to count the number of students in each category and how many of those students chose a specific availability time from a multi-select drop-down menu. This is what I came up with but doesn't work.

=COUNTIFS({Student Type}, "University Student", AND(HAS({Student Availability}, "Monday AM")

Can someone please help?

Thank you!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!