Announcing 24 New Formulas!

Kara Lumley · 07/07/19

Hi Brittany,

Thank you for the kind words!

Yes, we have a few different time management/handling enhancements on our roadmap. Feel free to email me (kara.lumley@smartsheet.com) for more details.

Thanks,

Kara

Shaine Greenwood · 07/09/19

Your wish is my command, Ezra: https://help.smartsheet.com/functions

Ezra · 07/09/19

Yeay! made my day

I know it's probably irrelevant to some, especially if you are just starting to use Smartsheet, but little bits of information like that can seriously help us keep moving forward. Also, it's a great way to show how feedback produces progress and results to your potential (as well as existing) customers.

Shaine Greenwood · 07/09/19

Totally agree — this was an oversight on my part. I forgot to add the release date when writing these articles so the "new" tags didn't appear.

Good catch and thanks for your insight.

Theresa Goodwin · 07/09/19

Very excited about the mention of possible formula support in the contact columns!!!

Christopher Brown · 07/09/19

Awesome. Great to see the announcement and your name to pop up in the feed!

I hope you're great Kara and thanks again to you and your team.

- Chris

Kara Lumley · 07/11/19

Hi everyone,

The DESCENDANTS fix is in place - thanks for the call out!

Kara

Paul Newcome · 07/11/19

Awesome! I like how it was fixed on already existing sheets as well which saved me from having to recreate anything just to take advantage of the fix.

Thanks Kara!!

Julie Green · 09/04/19

awesome!!

Hackathon sounds like a fun time!

kim.wade56346 · 10/15/19

Can you use the new CONTAINS in a COUNTIF formula?

To be more specific, when using a multi-select column I want to count how many times a certain value is selected.

Andrée Starå · 10/16/19

Hi Kim,

Yes, you sure can!

Here's a sheet describing how: https://app.smartsheet.com/b/publish?EQBCT=70b25596861440c89a85609e85714bfe

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome · 10/16/19

Yes you can. Andree's link to the published sheet is a great example of this very thing in action. You would first designate your range, then the CONTAINS function would be your criteria.

CONTAINS is a true/false type of function, and if you do not specify what type of result you are wanting then it defaults to true.

=COUNTIFS(range:range, CONTAINS("text", @cell))

is the same as

=COUNTIFS(range:range, CONTAINS("text", @cell) = true)

.

To count how many cells do NOT contain "text", you would need to either use a NOT function or specify false (or even specify not true - user preference)

=COUNTIFS(range:range, CONTAINS("text", @cell) = false)

=COUNTIFS(range:range, CONTAINS("text", @cell) <> true)

=COUNTIFS(range:range, NOT(CONTAINS("text", @cell)))

kim.wade56346 · 10/18/19

Thanks!

Andrée Starå · 10/18/19

Happy to help!

Announcing 24 New Formulas!

Comments

Categories