Thank you for the kind words!
Yes, we have a few different time management/handling enhancements on our roadmap. Feel free to email me ([email protected]) for more details.
Your wish is my command, Ezra: https://help.smartsheet.com/functions
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.
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.
Very excited about the mention of possible formula support in the contact columns!!!
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.
The DESCENDANTS fix is in place - thanks for the call out!
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.
Hackathon sounds like a fun time!
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.
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!
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET PARTNER & CONSULTANT / EXPERT
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.
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)))
Happy to help!