New Functions and Notification Controls

Shaine Greenwood
Shaine Greenwood Employee
edited 09/13/17 in General Announcements
Hello Smartsheet Community!

Happy Monday! We released some new features over the weekend. Below is a description of the new features and relevant help content to learn more:

  • Three New Functions:

    • SMALL—Find the n-th lowest value in a range.

    • LARGE—Find the n-th highest value in a range.

    • COLLECT—Used within another function to gather only values that meet a certain criteria.

  • New Notification Controls—Control who can receive notifications on a sheet and account level. With this feature, you can allow anyone with a valid email address to receive notifications, even if they’re not shared to the sheet.
You can find overview of new features, plus a list of bugs fixed in this release, later this week in our Release Notes site:


  • Matt Stofka
    Matt Stofka ✭✭✭✭✭✭

    Great job on adding notifications for non-sharers!  I really needed this and already implemented it on one of our sheets.



  • COLLECT function is a great addition without doubt!


  • Really like the "Collect" function and new notification controls. Could you please let me know, where I can find the product raodmap for this year?


  • New notification applies to users even if they are not shared to the sheet but the message when you create notification still says "Notification will be sent only to users shared to this sheet".

    Screen Shot 2017-09-13 at 1.45.49 PM.png