Is it possible to email only some information from a sheet via workflow?
As an example, say I have a sheet with data columns:
Name - User ID - Phone - Address - Email
The data is entered via a form, and I need to set a workflow to email all contact information from new entries to another team for various system updates, but User ID is sensitive personal data and cannot be shared.
What is the simplest solution?
Thanks!
Best Answers
-
Hi,
You can create a workflow triggered when New rows are added. Then for action you can choose Request an update and include emails of people (or contacts) you want it to be shared and message.
As you want to share with them only chosen fields you can mark them: Message includes - specific fields:
Hope this helps :)
Best,
Beata
-
Hi Liz W,
When setting up an Automation to Alert someone, you can include the name of the column in curly brackets.
The system picks up the data in the relevant cell of that column, so that the email recipient receives normal text.
Alternatively, (or as well) you could automate an update request, with a change to the subject line and choice of fields to be shown.
Would either of these work for you?
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
Answers
-
Hi,
You can create a workflow triggered when New rows are added. Then for action you can choose Request an update and include emails of people (or contacts) you want it to be shared and message.
As you want to share with them only chosen fields you can mark them: Message includes - specific fields:
Hope this helps :)
Best,
Beata
-
Hi Liz W,
When setting up an Automation to Alert someone, you can include the name of the column in curly brackets.
The system picks up the data in the relevant cell of that column, so that the email recipient receives normal text.
Alternatively, (or as well) you could automate an update request, with a change to the subject line and choice of fields to be shown.
Would either of these work for you?
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
-
Thank you Jason and Beata - that is very helpful. I am going to go try that now!
Liz
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives