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!