Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

COUNTIFS w/ new multi select dropdown

✭✭
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!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions