COUNTIFS w/ new multi select dropdown

Options

lleslie001

lleslie001 ✭✭

10/02/19 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!

Tags:

0 ·

Comments

Andrée Starå ✭✭✭✭✭✭

10/02/19
Options
Hi,

Have you tried CONTAINS?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
0 · Share on Facebook Share on Twitter
Paul Newcome ✭✭✭✭✭✭

10/03/19
Options
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".

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter
Jordan Borchardt ✭✭

04/30/20
Options
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

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

On a published calendar (created using the Calendar App), the Filter a greyed out. Why?
When I look at my Calendar, I see the filters I created, but someone else without or with an SM license can see the license.
Index | Match: How to Return Specific Value in Blank Cells
Hello! I am using an Index & Match formula to populate the following fields based on the chosen Integrated Participant: Group, RHMID, Class of Trade, and GPO Start date. I want any blank cells (aka, data not assigned to an Integrated Participant) to display #NO MATCH. I am using IFERROR statements (below) that will return…
Same Value in a column
I want the values of the columns to be automatically the same all the way down the sheet unless I change the values. As new entries come in from the form it should automatically put in whoever I have listed.