Announcing 24 New Formulas!

2Next

Comments

  • 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 ([email protected]) for more details.

    Thanks,

    Kara

  • Shaine GreenwoodShaine Greenwood Employee
    edited 07/09/19

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

  • EzraEzra ✭✭

    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. :D 

  • Theresa GoodwinTheresa Goodwin ✭✭✭✭✭

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

  • edited 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

  • Hi everyone,

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

    Kara

  • Paul NewcomePaul 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!!

    thinkspi.com

    [email protected]

  • yes awesome!!

    Hackathon sounds like a fun time! 

  • edited 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å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

    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.

  • Paul NewcomePaul 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)))

    thinkspi.com

    [email protected]

  • Thanks!

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Happy to help!

    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.

Sign In or Register to comment.