Automation Question
Hello,
I'm trying to create an automation from a form that was created. I created a form so employees could request time off. When creating the automation for the manager to be alerted and to approve the request...I'm not sure how to include the requestor email to be notified when the manager approves it. How would I include the requestor email? Can someone please help? Thanks!
Best Answer
-
@Nkeiruka. Aguocha Create a Contact List column for "Requestor", then ask for the employee to select their name in that field. Then the Requestor column will show up in the workflow as an available destination for the approval alert.
If you don't want them to use a dropdown list on the form, there's another way. You still need a Contact List column for "Requestor", but also create a Text/Number column for "Requestor Email" and add that to the form for the user to fill in. In the Requestor contact list column, create a column formula:
=[Requestor Email]@row
This will pull the user-entered email into the contact list column and make it a valid contact to use for the approval alert.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
If you look at the pic, it only gives the option to send to the Approval Manager. I want an email to be sent to the requestor email when the manager approves or declines and not to the approving manager.
Thanks!
-
@Nkeiruka. Aguocha Create a Contact List column for "Requestor", then ask for the employee to select their name in that field. Then the Requestor column will show up in the workflow as an available destination for the approval alert.
If you don't want them to use a dropdown list on the form, there's another way. You still need a Contact List column for "Requestor", but also create a Text/Number column for "Requestor Email" and add that to the form for the user to fill in. In the Requestor contact list column, create a column formula:
=[Requestor Email]@row
This will pull the user-entered email into the contact list column and make it a valid contact to use for the approval alert.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives