Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
I set up a form and when I tested it, I did not get a confirmation email. Why is this?
Hi Amy,
Did you add your email in the end of the form?
Add a Send me a copy of my responses checkbox to the bottom of the form. If the form submitter checks the box, they’ll be able to enter their email address and receive an automated confirmation email that their form submission was accepted. The email will display the actual data they submitted.
More info:
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Ahh, I see now. Thanks so much for your help.
The user needs to request a confirmation email. I thought as an Administrator you could elect for a confirmation email to be sent automatically. Frankly, that's a feature that should be added.
Happy to help!
You can set it up to be automatic with a workflow that sends an alert to the submitter.
Would that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
How do you do that?
You'd add an Alert someone workflow.
Trigger: When rows are added
When Checkbox is Checked (can be a status field or what makes sense for your process)
Run workflow: When triggered
In the Alert someone section you'd change to Send to contacts in a cell to Created By (will only work if the submitter has to be logged in to Smartsheet to submit the form)
If they don't need to be logged in, you'd need to add a contact column where they can select or add their email address.
Make sense?
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Hi Andrée, Can you explain how to do:
"If they don't need to be logged in, you'd need to add a contact column where they can select or add their email address."
I want to have an open form for different requesters (company suppliers, not previously identified in our database) can request an approval, and after its reviewed THEY CAN RECEIVE AN EMAIL WITH THE CONFIRMATION. I cannot "choose" that email as a "contact from a cell" (I only get the option of "created by" and since they are not logging in with Smartsheet, that field does not provide the email. How can I make the "supplier email" field elegible for choosing it in the "contact from a cell"?
How can I define other emails (such as "approver") to be notified too?
Thanks and looking forward to your reply
Hey Andree, I don't get the "Created By" option. Can you do this same workflow based on the email address entered earlier in the form?
Example: person who fills out the form enters their email address, they select "yes" send me a copy, then they receive a confirmation copy of the form they filled out.
SDB-Jason
"Jack of all digital trades."
Is there really no way to do this without having the submitter login or manually check a box and enter their email? (I don't want it to be an option. They need to absolutely get an email after they submit the form with what they submitted without any extra work on their part.) What I'm experiencing is that if one step in my automated workflow gets hung up then the transaction is out there in limbo and the submitter can't even search their gmail to find what they submitted.
@gpkelly There is a way. All you do is add a field to your form for "Applicant Email". I assume you want to know who is submitting the form anyway so the "applicant email" is a must. Then set up the automation for any form submission (new row added) to send the confirmation email (Alert someone) to the email address in this contact column (Applicant Email). You can customize the email message and select any or all the columns you want to display in the confirmation email including the email subject line.
Be sure to change your workflow settings to allow this workflow to operate to any email address. Otherwise, it restricts the workflow to only emails under your account or people shared to your sheet.
