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

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…