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
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives