Update Request Automation not sending to free users despite "Unrestricted" Automation permissions?

Asher_Schulz
Asher_Schulz ✭
inSmartsheet Basics

I have an automated "Update Request" workflow set up on a sheet to send to contacts in a cell, and I'm getting a an error message saying that this email is not being notified, and that I need to change the Automation permissions to a less restrictive setting. The email address is for under our work domain, so that shouldn't be limiting it either.


I already have the Automation permissions set to "Unrestricted" and can't share the users to this sheet, as it has other information they shouldn't have access to.


I've also checked our System Administrator settings for notifications, and are set to allow notifications to any email domain as well. Is this a bug, or is there something else preventing these update request emails from being sent?

delivery errror message.png

Thanks!

Tags:
· Share on Facebook Share on Twitter

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi all,

    This issue is now resolved as of 6pm PST on August 21st! Workflows will successfully send emails to users who do not have Smartsheet accounts.

    Thank you for your patience as we looked into this.

    Cheers,

    Genevieve

    · Share on Facebook Share on Twitter
«1

Answers

  • Sarah Donnelly
    Sarah Donnelly ✭✭✭✭✭

    我提交了一份支持e票类似的问题arlier this week about alerts for an automation email not being sent to contacts in a sheet! I'm the sys admin for our organization and I even sent screenshots to show my settings were set to "Unrestricted" for the sheet automations and our account. Support just suggested maybe the users had unsubscribed from the workflow previously and closed the ticket. But these were first-time emails for these users on this sheet. Didn't get any other help so I'm still not sure why it's going on but it continues to happen. At least I'm not crazy.

    · Share on Facebook Share on Twitter
  • Asher_Schulz
    Asher_Schulz ✭
    I submitted a support ticket for a similar issue earlier this week about alerts for an automation email not being sent to contacts in a sheet! I'm the sys admin for our organization and I even sent screenshots to show my settings were set to "Unrestricted" for the sheet automations and our account. Support just suggested maybe the users had unsubscribed from the workflow previously and closed the ticket. But these were first-time emails for these users on this sheet. Didn't get any other help so I'm still not sure why it's going on but it continues to happen. At least I'm not crazy.<\/p>","bodyRaw":"[{\"insert\":\"I submitted a support ticket for a similar issue earlier this week about alerts for an automation email not being sent to contacts in a sheet! I'm the sys admin for our organization and I even sent screenshots to show my settings were set to \\\"Unrestricted\\\" for the sheet automations and our account. Support just suggested maybe the users had unsubscribed from the workflow previously and closed the ticket. But these were first-time emails for these users on this sheet. Didn't get any other help so I'm still not sure why it's going on but it continues to happen. At least I'm not crazy. \\n\\n\"}]","format":"rich","dateInserted":"2023-08-02T21:29:44+00:00","insertUser":{"userID":90231,"name":"Sarah Donnelly","url":"https:\/\/community.smartsheet.com\/profile\/Sarah%20Donnelly","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-05\/5c\/e1\/n5ce1094bdd06e7b57825f0cdf0860fa2.JPG","dateLastActive":"2023-08-22T13:20:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388612#Comment_388612","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/388612#Comment_388612

    I've submitted a ticket as well - hopefully they'll give a helpful response now that a 2nd ticket has been created for this issue!

    · Share on Facebook Share on Twitter
  • Genevieve P.
    Genevieve P. Employee Admin
    edited 08/08/23

    Hi@Asher_Schulz&@Sarah Donnelly

    We received reports of this block and notification happening (even when the restriction permissions were set correctly to "unrestricted") if one of the emails that the workflow is sending to does not have a Smartsheet account.

    This is currently under investigation and I'll follow-up on this thread when it's been resolved.

    If this does not describe your issue, please keep following up with Support, providing them with as much context and details as possible!

    Thank you,

    Genevieve

    · Share on Facebook Share on Twitter
  • Brittany Lambert
    Brittany Lambert ✭
    edited 08/04/23

    I have been having the same issue for the last two weeks. It is random on who is not receiving the automated emails and we received the same error message again today, so it has not been fixed. Has anyone had any luck troubleshooting? I submitted my ticket two days ago. I have not heard an update yet.

    · Share on Facebook Share on Twitter
  • Asher_Schulz
    Asher_Schulz ✭
    I have been having the same issue for the last two weeks. It is random on who is not receiving the automated emails and we received the same error message again today, so it has not been fixed. Has anyone had any luck troubleshooting? I submitted my ticket two days ago. I have not heard an update yet.<\/p>","bodyRaw":"[{\"insert\":\"I have been having the same issue for the last two weeks. It is random on who is not receiving the automated emails and we received the same error message again today, so it has not been fixed. Has anyone had any luck troubleshooting? I submitted my ticket two days ago. I have not heard an update yet.\\n\"}]","format":"rich","dateInserted":"2023-08-04T16:00:22+00:00","insertUser":{"userID":164590,"name":"Brittany Lambert","title":"Associate Registrar","url":"https:\/\/community.smartsheet.com\/profile\/Brittany%20Lambert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-04T16:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388975#Comment_388975","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/388975#Comment_388975

    At least for my contact columns, it did fix it to remove the contact from the cell, save, and add it back.


    I'm not sure if that would necessarily help for notifications sent to a specific email address listed in an automation though.

    · Share on Facebook Share on Twitter
  • Brittany Lambert
    Brittany Lambert ✭

    Thanks, Asher, I'm not sure why it worked fine until about a week and a half ago. The fact that it suddenly came on and is random makes me think that this was an update in the software or something.

    · Share on Facebook Share on Twitter
  • Sarah Donnelly
    Sarah Donnelly ✭✭✭✭✭

    Smartsheet support contacted me today after I send a bunch of additional info late yesterday afteroon. Multiple reports have been coming in. Engineering is working on it. So that is helpful.

    · Share on Facebook Share on Twitter
  • ajtaylor
    ajtaylor ✭✭

    Good to hear they are working on it. I submitted a ticket a few days ago and hadn't heard back. Our notification emails go outside our domain so at first thought we were blocking it.

    · Share on Facebook Share on Twitter
  • W. M. Schlosser Co
    W. M. Schlosser Co ✭

    We are having the same issue. The above comment notes the issue has been resolved as of the 3rd, however we received this error message on the 5th and 6th, so it appears to still be an ongoing issue. I submitted a ticket with support aswell.

    · Share on Facebook Share on Twitter
  • Asher_Schulz
    Asher_Schulz ✭

    Good to hear engineering is working on it. Our problem was fixed for a few days, but we're having the same issue again.

    · Share on Facebook Share on Twitter
  • Lindsay O
    Lindsay O ✭

    I am continuing to have this issue except now it isnt even showing me which email...

    工作流Delivery Alert

    The following people included in theCustomer - Credit Card Prepayment Receipt Notificationworkflow for "LED Credit Card Authorization Form" are not currently being notified:

    +1 more

    If you want them to receive notifications, share them toLED Credit Card Authorization Formor change your Automation permissions to a less restrictive setting.Find out how


    Best Regards,

    The Smartsheet Team

    · Share on Facebook Share on Twitter
  • Sarah Donnelly
    Sarah Donnelly ✭✭✭✭✭

    I am still having this issue including yesterday. I have not received any email from Support telling me that the issue has been resolved or that they have figured out what is going on. But, this morning I get an email from Support saying "We haven't heard from you so we are closing your case??!!?? I responded that the case is NOT solved and I'm still waiting to hear from them. I'm a little disappointed in Smartsheet support.

    · Share on Facebook Share on Twitter
  • Nick Burrus
    Nick Burrus ✭✭✭✭✭✭

    Having this issue as well. We had a major survey sent out to a lot of people today and most came back blocked.

    Dr. St Nicholas Burrus DHA, PMP

    I build Smartsheets for the US Government, State Government, and about a dozen of the US Fortune 100s.

    · Share on Facebook Share on Twitter
  • Genevieve P.
    Genevieve P. Employee Admin

    Hi all,

    Our product development team is working on a solution with high priority - I don't have an ETA for this yet but I'll update the thread here when we know more.

    Thanks,

    Genevieve

    · Share on Facebook Share on Twitter
  • MATF12
    MATF12 ✭✭

    To add to this, I don't think the issue is with having a Smartsheet account. The form attached to the sheet requires users to login with a user account (so we can track who input the information). The notification is a receipt type notification when rows are added meeting certain criteria, and this specific person used the same login information and email as the email address the workflow should have sent the email to.

    · Share on Facebook Share on Twitter

Categories

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-27T02:16:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":47,"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-27T02:16:35+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":27,"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

  • JOIN() Formula Result - Producing Apostrophe in Copied Cell Data

    The issue involves the usage of the JOIN() formula within SmartSheet, which is resulting in the inclusion of an unwanted apostrophe when the formula's output is copied to another sheet. The JOIN() function is designed to concatenate values, but in this scenario, the copied data is displaying an apostrophe that is not…

  • IF / OR formula then Check a Box

    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))

  • Conditional Formatting (modified date not in the last 3 weeks)

    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…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video