Sheet Owner on Automation Emails

When a notification is sent, the automation email is sent like it is coming from the Sheet Owner rather than the user that actually updated the row and triggered the notification. This is confusing because often times our customers don't know who the sheet owner is or they don't interact with that person. Can this be changed to something more generic like "Smartsheet Notification" so the end users realize a person isn't sending them something?

Best Answer

  • Susan Peck
    Susan Peck ✭✭✭✭✭✭
    Answer ✓

    Hi Chris,

    There are several threads about this change Smartsheet made last year. Please add your voice to the feature request to give us the option to have automated emails sent from the sheet owner or a generic address. See this thread here for more:

    Today the proposed changes to automated update requests \/ notification has now got the OWNER's name in the email.<\/p>

    This is causing us absolute chaos.<\/p>

    Update requests have been sent out and as they now have the owner’s name (in our case this morning Kirsten Cox) the owner is now receiving lots of emails from people asking questions about the update request.<\/p>

    Kirsten, as a licenced user, has created the smartsheet but it is being used and operated by another team member.<\/p>

    Kirsten has no involvement in the content but is now inundated with a 100 emails.<\/p>

    To add further panic – we currently have 32 smartsheets as a new adopter, Kirsten has created about 4 and I have created all the rest – so I’m likely to be absolutely swamped.<\/p>

    Is there any way we can<\/p>

    1. Turn it off \/ revert back to from Smartsheet<\/li>
    2. Put someone else’s name as showing who the update requests are from (in this example James Potter a team member and free user)<\/li><\/ol>

      Really need urgent help on this matter as just starting a major testing cycle with approximately 400 test plan over the next 10 days and if all update request emails are going to come from the owner….. well just don’t know how we will cope.<\/p>","bodyRaw":"[{\"insert\":\"Today the proposed changes to automated update requests \\\/ notification has now got the OWNER's name in the email.\\nThis is causing us absolute chaos.\\nUpdate requests have been sent out and as they now have the owner’s name (in our case this morning Kirsten Cox) the owner is now receiving lots of emails from people asking questions about the update request.\\nKirsten, as a licenced user, has created the smartsheet but it is being used and operated by another team member.\\nKirsten has no involvement in the content but is now inundated with a 100 emails.\\nTo add further panic – we currently have 32 smartsheets as a new adopter, Kirsten has created about 4 and I have created all the rest – so I’m likely to be absolutely swamped.\\nIs there any way we can\\nTurn it off \\\/ revert back to from Smartsheet\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"Put someone else’s name as showing who the update requests are from (in this example James Potter a team member and free user)\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"Really need urgent help on this matter as just starting a major testing cycle with approximately 400 test plan over the next 10 days and if all update request emails are going to come from the owner….. well just don’t know how we will cope.\\n\"}]","format":"rich","dateInserted":"2020-04-17T13:18:11+00:00","insertUser":{"userID":117294,"name":"SueinSpain","title":"Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/SueinSpain","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!u7DUl-9NpGY!!6ZDtfnFmfzH","dateLastActive":"2023-08-14T13:14:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/67525\/upcoming-changes-to-our-automated-notifications-live-today-17th-april-2020","embedType":"quote","name":"Upcoming changes to our automated notifications - live today 17th April 2020"}"> https://community.smartsheet.com/discussion/67525/upcoming-changes-to-our-automated-notifications-live-today-17th-april-2020

    susan

Answers

  • Susan Peck
    Susan Peck ✭✭✭✭✭✭
    Answer ✓

    Hi Chris,

    There are several threads about this change Smartsheet made last year. Please add your voice to the feature request to give us the option to have automated emails sent from the sheet owner or a generic address. See this thread here for more:

    Today the proposed changes to automated update requests \/ notification has now got the OWNER's name in the email.<\/p>

    This is causing us absolute chaos.<\/p>

    Update requests have been sent out and as they now have the owner’s name (in our case this morning Kirsten Cox) the owner is now receiving lots of emails from people asking questions about the update request.<\/p>

    Kirsten, as a licenced user, has created the smartsheet but it is being used and operated by another team member.<\/p>

    Kirsten has no involvement in the content but is now inundated with a 100 emails.<\/p>

    To add further panic – we currently have 32 smartsheets as a new adopter, Kirsten has created about 4 and I have created all the rest – so I’m likely to be absolutely swamped.<\/p>

    Is there any way we can<\/p>

    1. Turn it off \/ revert back to from Smartsheet<\/li>
    2. Put someone else’s name as showing who the update requests are from (in this example James Potter a team member and free user)<\/li><\/ol>

      Really need urgent help on this matter as just starting a major testing cycle with approximately 400 test plan over the next 10 days and if all update request emails are going to come from the owner….. well just don’t know how we will cope.<\/p>","bodyRaw":"[{\"insert\":\"Today the proposed changes to automated update requests \\\/ notification has now got the OWNER's name in the email.\\nThis is causing us absolute chaos.\\nUpdate requests have been sent out and as they now have the owner’s name (in our case this morning Kirsten Cox) the owner is now receiving lots of emails from people asking questions about the update request.\\nKirsten, as a licenced user, has created the smartsheet but it is being used and operated by another team member.\\nKirsten has no involvement in the content but is now inundated with a 100 emails.\\nTo add further panic – we currently have 32 smartsheets as a new adopter, Kirsten has created about 4 and I have created all the rest – so I’m likely to be absolutely swamped.\\nIs there any way we can\\nTurn it off \\\/ revert back to from Smartsheet\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"Put someone else’s name as showing who the update requests are from (in this example James Potter a team member and free user)\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"Really need urgent help on this matter as just starting a major testing cycle with approximately 400 test plan over the next 10 days and if all update request emails are going to come from the owner….. well just don’t know how we will cope.\\n\"}]","format":"rich","dateInserted":"2020-04-17T13:18:11+00:00","insertUser":{"userID":117294,"name":"SueinSpain","title":"Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/SueinSpain","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!u7DUl-9NpGY!!6ZDtfnFmfzH","dateLastActive":"2023-08-14T13:14:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/67525\/upcoming-changes-to-our-automated-notifications-live-today-17th-april-2020","embedType":"quote","name":"Upcoming changes to our automated notifications - live today 17th April 2020"}"> https://community.smartsheet.com/discussion/67525/upcoming-changes-to-our-automated-notifications-live-today-17th-april-2020

    susan

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out theFormula Handbook template!
Hi, <\/p>

Instead of applying the formula to \"Multiselect Text String\" row, did you tried with \"Multiselect Values\" row?<\/p>

=IF(HAS([Multiselect Values]@row, [Component ID]@row), \"MATCH\", \"NO MATCH\")<\/p>

Thank you,<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":[]},{"discussionID":109493,"type":"question","name":"I am having trouble using \"And\", \"OR\" & \"Countif(s)\" to build a formula.","excerpt":"Hello, I am attempting to come up with a sheet summary formula that counts cells if they meet at least one of 3 different statuses in the same column, AND also meet one of 5 different statuses in a separate column. So using the screenshot I've provided as an example (although it doesn't have 5 different statuses in the…","snippet":"Hello, I am attempting to come up with a sheet summary formula that counts cells if they meet at least one of 3 different statuses in the same column, AND also meet one of 5…","categoryID":322,"dateInserted":"2023-08-25T20:03:21+00:00","dateUpdated":null,"dateLastComment":"2023-08-26T00:34:49+00:00","insertUserID":165710,"insertUser":{"userID":165710,"name":"SmarsheetNewb","url":"https:\/\/community.smartsheet.com\/profile\/SmarsheetNewb","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-26T00:33:27+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-26T01:04:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":22,"score":null,"hot":3386005690,"url":"https:\/\/community.smartsheet.com\/discussion\/109493\/i-am-having-trouble-using-and-or-countif-s-to-build-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109493\/i-am-having-trouble-using-and-or-countif-s-to-build-a-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":109493,"commentID":392692,"name":"Re: I am having trouble using \"And\", \"OR\" & \"Countif(s)\" to build a formula.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392692#Comment_392692","dateInserted":"2023-08-26T00:34:49+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-26T01:04:51+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-26T00:33:25+00:00","dateAnswered":"2023-08-25T20:44:12+00:00","acceptedAnswers":[{"commentID":392662,"body":"

Try this:<\/p>

=COUNTIFS([Item Number]:[Item Number], OR(@cell = \"C001\", @cell = \"COO2\", @cell = \"COO3\", @cell = \"COO4\"), [Status]:[Status], OR(@cell = \"Green\", @cell = \"Yellow\", @cell = \"Red\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":109474,"type":"question","name":"Help with date calculation formula","excerpt":"Hello, I'm trying to find a formula that will help me calculate how long an intake took to resolve. The rows I need to be calculated are Date Reported & Resolution Date. If the resolution date is blank I want it to use the current date in the calculation to see how long this issue has gone unresolved. Any help is much…","snippet":"Hello, I'm trying to find a formula that will help me calculate how long an intake took to resolve. The rows I need to be calculated are Date Reported & Resolution Date. If the…","categoryID":322,"dateInserted":"2023-08-25T16:29:39+00:00","dateUpdated":"2023-08-25T16:29:59+00:00","dateLastComment":"2023-08-25T23:01:30+00:00","insertUserID":165688,"insertUser":{"userID":165688,"name":"Nwest","title":"Systems Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Nwest","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ukHVZ18ImX4!BcjWAe8S9SY!l7iQo_PZHOx","dateLastActive":"2023-08-25T17:22:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":165688,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":23,"score":null,"hot":3385987269,"url":"https:\/\/community.smartsheet.com\/discussion\/109474\/help-with-date-calculation-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109474\/help-with-date-calculation-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":109474,"commentID":392687,"name":"Re: Help with date calculation formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392687#Comment_392687","dateInserted":"2023-08-25T23:01:30+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-25T17:04:22+00:00","dateAnswered":"2023-08-25T16:36:59+00:00","acceptedAnswers":[{"commentID":392622,"body":"

\n \n https:\/\/community.smartsheet.com\/discussion\/109474\/help-with-date-calculation-formula\n <\/a>\n<\/div>\n

Hi, <\/p>

I hope you're well and safe!<\/p>

Try something like this.<\/p>

=IF([Date Reported]@row <> \"//www.santa-greenland.com/community/discussion/74593/\", IF([Resolution Date]@row = \"//www.santa-greenland.com/community/discussion/74593/\", NETDAYS([Date Reported]@row, TODAY()), NETDAYS([Date Reported]@row, [Resolution Date]@row)))<\/p>

Did that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic weekend!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&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":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Formulas and Functions