Announcing 24 New Formulas!

Kara Lumley

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

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

Ezra

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

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

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

Christopher Brown

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

Hi everyone,

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

Kara

Paul Newcome

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

 awesome!!

Hackathon sounds like a fun time! 

kim.wade56346

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å

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

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

Thanks!

Andrée Starå

Happy to help!