Is there a way to automatically email the submitter their completed form information instead of relying on the user to select to email a copy of their submission?
Hey @eric.wong.compass You can add their email address field (type: contact) to the sheet/form (so they must enter it) and create an automation that sends an alert to them with their field data. I recently recorded a video for someone else that's similar to what you're asking... https://www.youtube.com/watch?v=3Y1NOFsfp5w
Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube
Come Say Hello!
@Ryan Sides appreciated! Exactly what I was looking for thank you!
@Ryan Sides something else possibly useful to the community, for my use case I didn't want to bother the user with checking a response box so I defaulted it to checked & then hid it on the form so once the user submitted the form, it automatically sent them a confirmation of their submission. Worked great and was the customer friendly option I was looking for. Appreciate you sharing.
@eric.wong.compass That works too! To take this a step closer to "optimized", you can eliminate the checkbox altogether and change your Automation to send an email to the user to run when a new row is created. Either way, it's doing what you need, so #winning. 😀
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
Hello, I have this formula to return the number of items that have not been ordered. The formula works perfectly so I want to make it a column formula but get the below error. =COUNTM(PPE10) + COUNTM(Tooling@row) + COUNTM(Consumables@row) + COUNTM([QEW LOTO]@row) + COUNTM([Rigging/Basket Access]@row) + COUNTM(Fillers@row)…
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.