COUNTIFS w/ new multi select dropdown

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!

Find more posts tagged with

Sheets

Formulas

Comments

Andrée Starå

Hi,

Have you tried CONTAINS?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

Are you able to provide the formula you are currently working with?

Screenshots are always helpful as well. Sensitive/confidential information can be hidden, removed, or replaced with "dummy data".

Jordan Borchardt

Im also having a issue with multiple Drop downs.

From My Metric sheet

=COUNTIFS({DEPT Resources Needed}, CONTAINS("Inventory", {DEPT Resources Needed}))

Collecting data from tear sheet

its not adding up

Sign in to join the conversation!

Quick Links

Trending discussions

Help with High Priority Function
Hi! I am relatively new to Smartsheet and trying to figure out how to program a sheet I am working on. I have one sheet holding many rows, each row representing a different project. For each project, the user is able to mark the priority as high, medium, or low, using the built in Smartsheet symbols. The goal is to make it…
Counting specific names in a table from a specific drop down menu
Hello everyone, I am trying to create a cell that calculates the number of times a certain name shows up whenever a criteria is chosen from a dropdown menu. Currently, I have Column E with a dropdown menu of names (uses data from Column L). Column F will use that cell as a reference to populate a cell using VLOOKUP…
Conditional Formatting Query
All the above rules are working except the 4th one in the list which asks for the cell to turn red if Group status is not started and end date is in next 14 days. I have used the Smartsheet AI tool but no luck, I have saved and refreshed. I am using a helper column for my 5th rule in the list which asks the cell to turn…