Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Send Row to Email Pre-Populated from a Given Column

Options
John Sauber
John Sauber ✭✭✭✭✭✭
edited 12/09/19 in Archived 2015 Posts

It would be neat if in the "Send Row" dialogue, we could check a box or some equivalent function, to populate the send-to email with the value of a given column, or the contact column-type.

 

This would allow us to potentially send many rows at a time, with each row going to an email address or contact field-type associated with that row.

 

This would allow rows to be sent to non-Smartsheet users' email addresses.

 

Since the attachment links expire after 30 days, it would also be nice to have the option to include attachements as actual attachments, instead of links. One can imagine a case where one wouldn't want the attachments to expire, or to have a potentially publicly-accessible link to a sensitive document (you can find any attachment's public URL by simply right-clicking the hyperlink which appears for the attachment in an email).

 

Thoughts?

Comments

  • Eric Browne
    edited 10/16/15
    Options

    You can set a reminder on a sheet that gets sent to the Assigned To (or other contact list column).  We're looking at how we could enable a similar capability for notifications (e.g., Notify the Assigned To user if a row they're assigned to changes).  Makes sense to look to enable for Send Row/Send Update Request.  Will make sure it's on the enhancement list for those features.

     

    We'll also look into the attachment options you're asking for.

     

    Thanks for the input!

  • Joel Johnson
    Options

    Put my vote in for this upgrade as well.

  • Alina Anderson
    Alina Anderson Employee
    edited 10/16/15
    Options

    Great suggestions!

  • John Sauber
    John Sauber ✭✭✭✭✭✭
    Options

    Thanks for the feedback, everyone!

  • Thomas G.
    Thomas G.
    edited 10/23/15
    Options

    Same.

     

    I try to do it with Zapier but can't manage to detect what row and what column has changed.

  • Patrick Lawler
    edited 10/26/15
    Options

    John and group.

     

    This exact problem can be solved using Azuqua, an integration partner of Smartsheet. I work for Azuqua and the conditional notification scenario you referred to is one of the many scenarios we enable inside of Smartsheet. 

     

    Using Azuqua you can set up a monitor for a change either to a row, column, discussion or new row added to a sheet and then send a notification to a person assigned to that row. The notification can also be based on matching a specific condition of a cell inside that row as well. 

     

    If you want to learn more please visit our app listing at Smartsheet here:

    https://www.smartsheet.com/apps/azuqua

     

    Please feel free to follow up with any questions. 

     

    -Patrick 

     

     

This discussion has been closed.