Workflow "Alert Someone" | Send to a contact in a cell
Hello Smartsheet Community,
I am trying to create a workflow in Smartsheet using "Alert Someone" that will notify the Manager and Employee (two separate cells) that the specific task has been completed.
Under "Alert someone" I choose "Send to contacts in a cell" however that cell is defaulted to "Created by"….
Questions: Is it possible to change this to any one or more cells other than "Created by"? Or are there any other ways around this?
Open to any ideas 💡
Thank you in advance. 🙂
Answers
-
@Nicolas (Nic) Gonzalez When you select contact is a cell you can select from the various contact columns in your sheet. I'm assuming that your created By is the only contact column available; if you add others they'll be your options.
-
@Razetto Thanks for your answer.
What if your column type is a column: Text/Number?
The column is a free form, therefore the person filling out the form would type their email address. Whatever is in this field, I want the workflow to send an email to this cell.
-
@Nicolas (Nic) Gonzalez You can use a contact column type instead and the person can still enter an email address.
-
@Razetto thank you so much! That was great and worked! Life savor!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Can I link a Smartsheet report in a form. My form will be for a person to confirm info from a report is correct. So I want the user to be able to view the report while filling out the form.
- I have 4 sheets used by individuals to track their work. I have a report that pulls from all 4 of those sheets to give me a total count of items they listed for the month as well as each line item (de…
- Hi All! Quick question - I am working on a form with a lot of yes or no questions, and I decided to display them as horizontal radio buttons. They are all circles except for one question, which shows …
