Notifications to email address in a column

Chokri Guetari

Is it possible to send a notification/email to an email address that is captured in one of the columns of a sheet?

J. Craig Williams

As long as the email address is in a Contact List type column, then yes.

 

See this video on Alerts:

 

https://youtu.be/TUMNxBxjlsc

 

Craig

Chokri Guetari

Thanks Craig. It looks like a requirement is that the sheet is shared with the email addresses in the Contact column. In my case I just want to send an email with some text without giving the person visibility to the data in the sheet. Any thoughts on this would be great.

Shaine Greenwood

Hello Chokri,

 

There isn't a way to use the Contact column to send emails to people that aren't share on the sheet; however, you can manually send rows with the steps in our Help Center: https://help.smartsheet.com/articles/504773-sending-sheets-rows-via-email

quinlyn.jackson

Hi Shaine!



I'm wanting to do the same thing as Chokri (send notification to email on the sheet). 



Does sharing the sheet with someone require them to have a license?

Shaine Greenwood

Hi Quinlyn—

One thing you might consider is configuring your sheet to send notifications out to anyone with an email address. You can now send notifications to people without them having to create a Smartsheet account and be shared to the sheet. This feature was added to Smartsheet after this community discussion was created, but it's an option for us now! 

This is a setting that can be changed on a sheet-level and on an account-level. Here are two articles discussing the feature:

• Sheet-level: https://help.smartsheet.com/articles/2476586-control-who-can-receive-notifications-from-your-sheet 
• Account-level: https://help.smartsheet.com/articles/1159581-global-account-settings-team-business-enterprise-

To answer your question: People don't have to have a paid license to be shared to a sheet, but they do need to create a free account to access the sheet. When you share a sheet to an email address that hasn't been used for Smartsheet, they'll be prompted to make a free account to access it.

Let me know if you have any questions on this.

Rekaughn

Hello guys, one of our tabs is used to track employee contact information, like emails. We send out weekly emails to our employees, but we do this in Outlook, manually inserting and deleting addresses. Often, Smartsheet is updated but Outlook is not since it is managed by two separate people and this information can change frequently throughout the week due to our type of field project work.

Is there a way we can import this column into Outlook (To:) each time or email straight from Smartsheet without them having to create accounts? Our turnover is too frequent to have them create an account; many would not anyway, but we'd still need to get them the information somehow, whether they read it or not.

Thank you