Two new functions released (COUNTM & HAS)

Hi everyone,

I noticed that two new functions has been released.

COUNTM and HAS

Here are the details.

COUNTM

Counts the number of elements in a multi-contact or multi-select dropdown column cell or cell range. Returns the total number of elements found.

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

HAS

Search for an exact match of a value, including multi-contact or multi-select dropdown column cells or ranges. Returns true if found, false if not found.

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

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Find more posts tagged with

Formulas

Comments

Paul Newcome

Like them both! But I would have to say the HAS function is going to be more of a game changer for me than the COUNTM.

Having the two features of being CaSe SeNsItIVe and the ability to look for a very specific text... HAS is a GREAT addition. The example they used is a good one. Searching for "app" won't return a false positive on a cell containing "apple".

What I don't understand is that I was just on the Functions List last week and didn't see them, but they say they were added on the 9th?? How could I have missed those?

Andrée Starå

Yes, I agree!

Regarding not seeing them:

whereisit

Katrina Savage

Thanks for sharing Andrée - more great tips!

Andrée Starå

@Katrina Savage

You're more than welcome!

DDVL

How can I use the COUNTM and has function in a SUMIFS formula:

=SUMIFS([Per_Person_Total]:[Per_Person_Total], Payor:Payor, "Diane", Payee:Payee, COUNTM(HAS(Payee, "Sofia")))

How can I use COUNTM and HAS in the criteria part of this formula?

Genevieve P.

Hi @DDVL

These are two different functions:

COUNTM counts how many values are selected
HAS looks into a multi-select cell to see if it has one specific selection

In your instance it sounds like you just need the HAS function. Try this:

=SUMIFS([Per_Person_Total]:[Per_Person_Total], Payor:Payor, "Diane", Payee:Payee, HAS(@cell, "Sofia"))

Cheers,

Genevieve

Sign in to join the conversation!

Quick Links

Trending discussions

Issues with Attachments
Ok, I'm not new to Smartsheet but recently this simple automation has had me stumped. Pictured below is a simple automation we use to verify that an attachment has been added to each row in our system. IF attachment added or changed, THEN Change Cell Value. These worked beautifully all over our system until about a month…
Retrieving Cell info if another column falls between specific dates
Here is the formula I am trying and it's brining back #CIRCULAR REFERENCE =IF(AND([FPI Date]@row >= DATE({StartYr}, {StartMth}, {StartDy}), [Jan FPI]@row <= DATE({EndYr}, {EndMth}, {EndDay})), [eCOA_ID]@row , "")
Index/Match
I have two sheets that are capturing two different sets of data. Sheet 1 (Billable Mileage Log) is capturing projects that have been marked as needing mileage to be entered in a different platform. Sheet 2 is capturing mileage that's being entered via a Smartsheet form. On this sheet, I have two columns that have formulas.…