Update Request Confirmation Email Change

Caroline Sheldon
Caroline Sheldon Employee
edited 11/09/22 inSmartsheet Basics

Hi Community,

As many of you know, Smartsheet has always sent a confirmation email anytime someone responds to an update or approval request. Based on customer feedback, we have made the confirmation optional. Each respondent can now opt in to the confirmation by checking the box at the bottom of the request form.

This change will help reduce the number of emails from Smartsheet and applies toautomated approval requests,自动更新请求, andmanual update requests.

Thank you to everyone who chimed in on Community or sent enhancement requests. As the product owner for forms and requests, I read everything you write, and it helps my team prioritize our projects. Keep that feedback coming!


Best,

Caroline


opt-in-checkbox-green-button.png


«1

Comments

  • Thank you for making this change! It's a lot easier to "sell" the use of the tool and invest in the process.

  • Awesome, thank you for listening to our feedback!

  • Sam Fox
    Sam Fox ✭✭

    Thank you so much for making this change!

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Thank for making this change and for listening to our feedback

    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️Are you satisfied with my answer to your question? Please help the Community by marking it as an( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • @CollabMeganPMP
    @CollabMeganPMP ✭✭✭✭

    Does the person responding to the update request need to have a Smartsheet account in order for their responses to be sent to them via e-mail? Or does this work for any email address that an update request is sent to? We have been seeing the issue happen where those that do not have Smartsheet accounts are not receiving their update request responses after the update request is submitted whereas those that do have Smartsheet accounts are receiving the copy of their responses.

  • The person responding to the update request does not have to have a Smartsheet account. They need to have the update request sent to their email from Smartsheet or forwarded to them.

  • @CollabMeganPMP
    @CollabMeganPMP ✭✭✭✭

    So when Send me a Copy of my Responses is checked and the update request form is submitted, Smartsheet sends the responses to the e-mail address that the update request was originally sent to? I would guess in the case of a forwarded e-mail, the copy of the responses would not go to the person who was forwarded the e-mail, but rather the e-mail address that initially received the update request?

  • Ah I see your question now. Yes, Smartsheet does send the confirmation to the person the Update Request was originally sent to. That's the address we have on file and it isn't converted to the person you forwarded the request to.

  • @CollabMeganPMP
    @CollabMeganPMP ✭✭✭✭

    Thanks. One clarifying question....regardless if, for instance, Jane Doe does not have a Smartsheet account, but we allow update requests to be sent to any e-mail address, when she receives the update request and chooses to receive a copy of the response she is submitting, the responses should be automatically sent to her email address by Smartsheet even though she does not have an account?

  • 是的,如果Jane Doe的原始收件人update request, even if she doesn't have a Smartsheet account, she will still receive the invitation and the confirmation. People do not need a Smartsheet account to receive or fill out the update request. It does get a little tricky when you forward it because it's still associated in our system with the original recipient. Yes, the person you forwarded it to can certainly fill it out and complete it, but the request is still associated with that original email because that's the one we have in our system and because we don't require login / an account to fill it out we can't re-associate it with a new person it may have been forwarded to. Does that help?

  • @CollabMeganPMP
    @CollabMeganPMP ✭✭✭✭

    Yes. We are seeing, though, people that are in our organization without Smartsheet accounts, getting Update Requests. When they complete the Update Request and elect to receive a copy of their responses, they are not getting the confirmation e-mail. We are NOT seeing this issue with people that have Smartsheet accounts.

  • Ella
    Ella ✭✭✭

    @Caroline S.is there a way to make the confirmation e-mail a required field on the form?

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi@Ella

    I hope you're well and safe!

    Does the user have to be logged in to Smartsheet to access the sheet?

    Unfortunately, it's not possible at the moment, but it's an excellent idea!

    Please submit an Enhancement Request when you have a moment.

    As a possible workaround, you could remove the option, add another so-called helper column, set it as required, and use an automated workflow alert to send them the submission copy.

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic day!

    Best,

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please help the Community bymarking it as the accepted answer/helpful. 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:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Ella
    Ella ✭✭✭

    @Andrée StaråHi! I hope all is well!

    The users will not be logged into Smartsheet. They will be completing a form, a copy of which we would like to make sure gets e-mailed to them for a confirmation of submission.

    The workaround is not the best option as their e-mails will all be personal and outside of our organization, but I appreciate the suggestion.

    Thanks for your help!

  • Hi@Ella

    Unfortunately there isn't currently a way to make the 'Send me a copy' checkbox required. However, you can use something we call query string parameters to the end of your form link to automatically check that box. Please submit anenhancement requestfor what you would like to see with 'Send me a copy' and I can use this to prioritize features.

    Here is a help article about query string parameters, and it essentially allows you to control the fields in the form using the URL link.


    If you add ECA=%20 to the end of the form URL. Then you use that URL to send to your users. Here's an example:https://app.smartsheet.com/b/form/3914601098484df4ac0141b40e2cfe56?ECA=%20


    This automatically checks the box "Send me a copy" and shows the email box. The only thing is it is not required, so your user could uncheck it. You can edit the text in that email copy to whatever you want, including a hyperlink.


    The other option is to send anautomated alertafter the form submission.

    1. Add a contact field to your form and ask your users to enter their email.
    2. In the sheet, Click on Automations tab
    3. Set up a new automated alert
    4. When new rows are added
    5. send to contacts in a cell
    6. pick the contact cell where you asked the users for their email
    7. Click on the three dots for advanced options
    8. Then select which fields you want to be shown on the email they receive.
Fixed, needed to add \"Value\" before the formula to remove the apostrophe.<\/p>


<\/p>

=VALUE(IFERROR(JOIN(DISTINCT(COLLECT([Customer PO Amount (USD)]@row:[Customer PO Amount (Local Currency)]@row, [Customer PO Amount (USD)]@row:[Customer PO Amount (Local Currency)]@row, <>\"\"))), \" \"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":109460,"type":"question","name":"IF \/ OR formula then Check a Box","excerpt":"I need a formula that IF a specific column has either 1 of 2 specific choices, then a BOX in another column is checked: =IF(([Study Status]@row = \"Active\/ Open to Accrual\", 1) OR([Study Status]@row = \"In Start-Up\", 1))","snippet":"I need a formula that IF a specific column has either 1 of 2 specific choices, then a BOX in another column is checked: =IF(([Study Status]@row = \"Active\/ Open to Accrual\", 1)…","categoryID":321,"dateInserted":"2023-08-25T13:30:39+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T16:21:27+00:00","insertUserID":9250,"insertUser":{"userID":9250,"name":"Susan Swisher","url":"https:\/\/community.smartsheet.com\/profile\/Susan%20Swisher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T16:23:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-27T01:32:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":46,"score":null,"hot":3385956126,"url":"https:\/\/community.smartsheet.com\/discussion\/109460\/if-or-formula-then-check-a-box","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109460\/if-or-formula-then-check-a-box","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":109460,"commentID":392616,"name":"Re: IF \/ OR formula then Check a Box","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392616#Comment_392616","dateInserted":"2023-08-25T16:21:27+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-27T01:32:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-25T15:13:03+00:00","dateAnswered":"2023-08-25T14:14:39+00:00","acceptedAnswers":[{"commentID":392575,"body":"

Give this a try:<\/p>

=IF(OR([Study Status]@row = \"Active\/Open to Accrual\", [Study Status]@row = \"In Start-Up\"), 1)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":109457,"type":"question","name":"Conditional Formatting (modified date not in the last 3 weeks)","excerpt":"I would like to use Conditional Formatting (highlight the entire row yellow) if the modified date is not within the last 3 weeks. So any row that has not been recently updated (last 3 weeks) should be highlighted in yellow. Is this spmething that can be done directly within conditional formatting or should I first create a…","snippet":"I would like to use Conditional Formatting (highlight the entire row yellow) if the modified date is not within the last 3 weeks. So any row that has not been recently updated…","categoryID":321,"dateInserted":"2023-08-25T12:33:14+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T12:40:57+00:00","insertUserID":161267,"insertUser":{"userID":161267,"name":"Jef Snyders","title":"Jef Snyders","url":"https:\/\/community.smartsheet.com\/profile\/Jef%20Snyders","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4HJAEW33KBD0\/nXEKEZE5EQEV4.jpg","dateLastActive":"2023-08-25T13:32:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161267,"lastUser":{"userID":161267,"name":"Jef Snyders","title":"Jef Snyders","url":"https:\/\/community.smartsheet.com\/profile\/Jef%20Snyders","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4HJAEW33KBD0\/nXEKEZE5EQEV4.jpg","dateLastActive":"2023-08-25T13:32:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3385935251,"url":"https:\/\/community.smartsheet.com\/discussion\/109457\/conditional-formatting-modified-date-not-in-the-last-3-weeks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109457\/conditional-formatting-modified-date-not-in-the-last-3-weeks","format":"Rich","tagIDs":[437],"lastPost":{"discussionID":109457,"commentID":392553,"name":"Re: Conditional Formatting (modified date not in the last 3 weeks)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392553#Comment_392553","dateInserted":"2023-08-25T12:40:57+00:00","insertUserID":161267,"insertUser":{"userID":161267,"name":"Jef Snyders","title":"Jef Snyders","url":"https:\/\/community.smartsheet.com\/profile\/Jef%20Snyders","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4HJAEW33KBD0\/nXEKEZE5EQEV4.jpg","dateLastActive":"2023-08-25T13:32:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-25T12:40:09+00:00","dateAnswered":"2023-08-25T12:37:47+00:00","acceptedAnswers":[{"commentID":392551,"body":"

There is no direct way to do this. Adding a checkbox helper column with something similar to this and then formatting based on the checkbox is the simplest way. You can even hide the extra column, as there is no reason for it to be visible.<\/p>

=IF([Modified Date]@row < TODAY(-21), 1, 0)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":4991,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics