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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Comments
-
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?
thinkspi.com
0 -
Yes, I agree!
Regarding not seeing them:
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
0 -
Thanks for sharing Andrée - more great tips!
0 -
You're more than welcome!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
0