If "Status" Changes Email "Form Submitted by"
Good afternoon,
I am reaching out to ask how to set a rule for when a column changes, to send an email to the person who submitted the form.
I have a form that populates a sheet. I would like to set the rule "If status changes, notify person who submitted form." Is this possible and what would that rule look like? Thank you!
Deanna
Best Answer
-
This is definitely possible. I know of 2 options off-hand.
Option 1:
Add a Created By (system) column.
Force users to be logged into Smartsheet in order to submit the form. This will populate the Created By with the user name. This setting can be found when editing the form, and clicking "Settings".
Then you can use the value in that cell to email to via your automation.
Option 2:
Add a Submitted By column.
Have users enter their email into the form into the Submitted By column.
Then you can use the value in that cell to email to via your automation.
Hope this helps!
BRgds,
-Ray
Answers
-
This is definitely possible. I know of 2 options off-hand.
Option 1:
Add a Created By (system) column.
Force users to be logged into Smartsheet in order to submit the form. This will populate the Created By with the user name. This setting can be found when editing the form, and clicking "Settings".
Then you can use the value in that cell to email to via your automation.
Option 2:
Add a Submitted By column.
Have users enter their email into the form into the Submitted By column.
Then you can use the value in that cell to email to via your automation.
Hope this helps!
BRgds,
-Ray
-
Thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!