I have created a Smartsheet's form with an automated process behind it that sends approval requests based on certain criteria. Is there a way to change the naming on the email that people receive so instead of people receiving it as Name via Smartsheet <[email protected]> the name could differ.
I would prefer people to received all entries and notification as Access Log via Smartsheet <[email protected]>
An option used more is that you have another general user in your account that would own the sheets, and therefore that user's name (COMPANYNAME) would show instead.
Have a look at this post for information about possible workarounds.
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>
Turn it off \/ revert back to from Smartsheet<\/li>
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-07-28T07:42:59+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
✅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!
How exactly is your Data Shuttle set up? If it is set to replace everything in the sheet when it runs, it is deleting the cell being referenced by the widget and then putting new data in new cells.<\/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":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":108213,"type":"question","name":"How to spread costs evenly across months, if they fall within those dates","excerpt":"I have various financial line items that span different dates. I'd like the costs to be spread per month automatically based on the date and cost entry. I've tried various functions already, IF, AND, and it says Unpearsable. I'd like to spread out the costs in the Cost column to the months on the right, based on the start…","snippet":"I have various financial line items that span different dates. I'd like the costs to be spread per month automatically based on the date and cost entry. I've tried various…","categoryID":321,"dateInserted":"2023-07-27T19:03:42+00:00","dateUpdated":null,"dateLastComment":"2023-07-28T21:12:20+00:00","insertUserID":164209,"insertUser":{"userID":164209,"name":"AshwiniBiotech2023","title":"Sr. Director, Project Management","url":"https:\/\/community.smartsheet.com\/profile\/AshwiniBiotech2023","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T23:10:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":164209,"lastUser":{"userID":164209,"name":"AshwiniBiotech2023","title":"Sr. Director, Project Management","url":"https:\/\/community.smartsheet.com\/profile\/AshwiniBiotech2023","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T23:10:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":14,"countViews":65,"score":null,"hot":3381071762,"url":"https:\/\/community.smartsheet.com\/discussion\/108213\/how-to-spread-costs-evenly-across-months-if-they-fall-within-those-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108213\/how-to-spread-costs-evenly-across-months-if-they-fall-within-those-dates","format":"Rich","lastPost":{"discussionID":108213,"commentID":387925,"name":"Re: How to spread costs evenly across months, if they fall within those dates","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387925#Comment_387925","dateInserted":"2023-07-28T21:12:20+00:00","insertUserID":164209,"insertUser":{"userID":164209,"name":"AshwiniBiotech2023","title":"Sr. Director, Project Management","url":"https:\/\/community.smartsheet.com\/profile\/AshwiniBiotech2023","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T23:10:16+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/IBAVVE3YLO8D\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-28T09:38:32+00:00","dateAnswered":"2023-07-27T19:21:12+00:00","acceptedAnswers":[{"commentID":387646,"body":"
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"