Two new functions released (COUNTM & HAS)

Andrée Starå

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

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:

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