Automate sending an email referencing a column

I have a form where the public submits information for a schedule change. Can I set up a workflow so when I mark 'complete' in a column, I can reference the column where the email is located to send out an auto response that their request has been completed? These are non-smartsheet users who do not need any access to the sheet.

Find more posts tagged with

Education

Email Notifications

Comments

Andrée Starå

Hi Nathan,

Yes, you can! You'd select a contact column as the source for where to send the response.

Would that work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Nathan Winegar

Thank you. At first it looked like I still had to choose each individual person every time, but I found out how to just choose the column. Appreciate the help.

Andrée Starå

Excellent!

Happy to help!

Nathan Winegar

Andree,

I spoke too soon. It is not working. I created the workflow stating that when I change a column to 'completed' to Send to contacts in a cell and chose the column that those emails are listed. I tested my work and home email, and nothing has happened.

Andrée Starå

First, make sure that you have allowed yourself to receive notifications properly in your Personal Settings (circle/profile in the upper right corner) and secondly check the Permission.setting for the Automations. (cog in the upper right corner in the Automation overview)

Did that fix it?

Hope that helps!

Andrée Starå

Screenshots:

Pesonal Settings_2.png

Automation Permissions_1.png

Sign in to join the conversation!

Quick Links

Trending discussions

Dashboard Adding Widgets Spontaneously
Howdy, I am working on developing a several dashboards for our team, and for whatever reason the widgets I place are multiplying. I have copied/pasted some, but other I have just added I am ending up with dashboards that look like this: When originally I only had the top four items. It has happened on several different…
Project Management with tracking costs
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…