COUNTIFS w/ new multi select dropdown

lleslie001 ✭✭
edited 12/09/19 in Formulas and Functions

Hey all, I'm looking for a way to use the COUNTIFS function on a column that is Dropdown (Multi-Select).  I've seen a few tips about using "Find" but when referencing another column on a different sheet, keep returning an error.  For this example, I'm trying to count department names.


Thanks in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!