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.
Notifications to email address in a column
Comments
-
As long as the email address is in a Contact List type column, then yes.
See this video on Alerts:
Craig
-
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.
-
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
-
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? -
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.
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives