Announcing 24 New Formulas!

Kara LumleyKara Lumley Employee
edited 10/18/19 in General Announcements
07/03/19 Edited 10/18/19

Each year, Smartsheet hosts a hackathon called “Hack the Sheet.”

During this hectic, exhilarating, and productive week, our entire product and engineering teams get to work on projects they are super passionate about. We divide ourselves into teams based on interest, have some late nights, and are judged by peer and leadership panels. 

My team worked to build a number of new formulas, all highly requested by Smartsheet customers, that we believed would significantly improve user productivity. We set a goal of creating six new formula functions by the end of the hackathon. We ended up building 24! 

As many of these functions were on the wishlists of our most enthusiastic customers, we know they will help teams in every industry to be even more effective. For the complete list, check out the updated Smartsheet Formulas Example sheet and apply the filter named Formulas added in July 2019. 

We’re also releasing performance enhancements that will improve formula speed within your sheets and coming soon...formula support in contact columns!

We’re happy to share these changes with you, and look forward to many more to come.

Thank you,




  • EzraEzra ✭✭

    It would be nice to have an "Updated on" for each function on the Functions List page

    These are the ones just added:

    • CHAR
    • FLOOR
    • ISEVEN
    • ISODD
    • MOD
    • MROUND
    • NPV
    • RANKEQ
    • STDEVA
    • STDEVP
    • STDEVS
  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Kara,

    24 Wow! Thanks! smiley

    Performance enhancement! yes

    Formula support in contact column! cool

    Have a fantastic day!


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

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

  • Thanks Ezra, 

    We'll look into this.



  • BSullinsBSullins ✭✭✭✭✭

    Hi Kara,

    These are awesome! Great job to you and your team.

    Are there any plans on a time formula? I know this is something that has been requested for quite some time. Just wondering if we can see it in the near future. 



  • Paul NewcomePaul Newcome ✭✭✭✭✭

    I've been playing around with some of these, and have found quite a few interesting uses. Whether or not I'll actually need them is a different story, but they are interesting uses no less. Haha.


    I also know I am ready for that "coming soon" to change to "just released".

  • Mike WildayMike Wilday ✭✭✭✭✭

    Me: Doing a happy dance. 

    Dance The-Office.gif

  • Paul NewcomePaul Newcome ✭✭✭✭✭


  • Nick BurrusNick Burrus ✭✭✭✭✭


    Nick Burrus, MAOL, PhD Doctoral Candidate

    I build Smartsheets for the US Government, State Government, and about a dozen of the US Fortune 100s.

  • Thank you Kara and team - much appreciated.

  • Stefan 7kStefan 7k
    edited 07/04/19

    Thanks to Kara and her team !

    And thank you Ezra for the overview!

    Projektmanagement Professional in Frankfurt am Main, Germany

  • Hi Kara

    I am happy to get MOD and DESCENDANTS, so that I do not have to do the workarounds. Thank you team for your good efforts. Keep the good stuff coming.


    Best Regards

    Chak Khiam 

  • Sameer KarkhanisSameer Karkhanis ✭✭✭✭✭
    edited 07/05/19

    Based on the example for DESCENDENTS function/formula there is a potential bug in the value returned by this formula. Currently the value returned includes the parent row where as the actual value should exclude the requested row itself.

    For example, below should return 3 for the formula COUNT(DESCENDENTS([Column Name]100) but currently it returns 4

    where row 100 is 

    • Task 100
      • Sub Task of 100
        • Sub-sub Task of 100
          • Sub-sub-sub Task of 100
  • Sameer KarkhanisSameer Karkhanis ✭✭✭✭✭

    New formulas and functions are great add! Thanks SS team.

    Can we get some functions for PREDECESSORS and SUCCESSORS? Especially to get the predecessor task name from the row number

    Currently there is no way to know what are the successors of a given task are, so if someone deletes the task then it breaks the dependencies without any warning. 

    Also just displaying predecessor numbers in a report is of no use as there is no context of what the task associated with the number is. If we can have function to get the name of the task associated with the predecessor/successor # then that will be so much useful.





  • Thanks for letting us know! 

    We have a fix ready for this, and should know by Tuesday when we can deploy it. I'll update the thread then.


  • Hi SK,

    You're very welcome!

    We have some ideas on showing predecessors/successors - I'd love to run them by you and see if they would work for your use cases.

    If you'd like to send me an email at [email protected], I can give you an overview.



Sign In or Register to comment.