Multi-Select Formulas

First.....Im so happy the Multi-select feature is now available - so thank you.

This leads me needing some assistance. I have played around with a LOT Of different formulas trying o find a way to capture this information.

I am needing help with trying to find a formula to do a count of selected options that were placed in that field.

I have tried the Countifs formula (as well as a bunch of others0, but it will only count if the item selected was entered by itself and not in conjunction with others. or just gives me errors

Example:

Field 1: EPP, Driver, Faucet

Field 2: EPP, Faucet, Home

Field 3: EPP

Count of EPP only comes to 1 and not 3

Find more posts tagged with

Formulas

Comments

Andrée Starå

Hi,

Have you tried FIND or CONTAINS?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Kara Lumley

Hello,

If you are looking to count how many specific values in a multi-select column contains, this will work:

Soon, we'll release a few new functions that will let you easily search for specific values or counts of specific values in both the multi-select and multi-contact columns, as well as count how many values are in a cell (or range of cells).

Andrée Starå

Hi Kara,

New functions!

excited

Best,

Andrée

Paul Newcome

Hahaha. I may not have gotten quite THAT excited, but I definitely did get excited to read about these functions being able to look at individual entries within multi-select fields. That's going to make A LOT of people very happy.

JLC

Count me in, guys!!!

Andrée Starå

club

Samuel Tong

So i guess the function isn't out yet? I created the exact table and typed the exact formula, didnt work :(

Andrée Starå

Hi Samuel,

Which function? What do you want to do?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

J. Craig Williams

As Kara hinted, the formula COUNTM was added 2019-10-09 and does the counts described in the OP.

https://help.smartsheet.com/function/countm

Three use cases are described:

a) count elements in a single cell

b) count elements in a range

c) count elements (single cell or range) based on criteria.

As of today (2024-03-20), there is no "COUNTMS", allowing multiple range/criterion, though that would be useful.

Regards,

Craig

Sign in to join the conversation!

Quick Links

Trending discussions

Dropdown list restrictions
Is there a way to limit a dropdown list so that the values in the dropdown list can only be used once in a column?
seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet