Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Formatting Notifications to be Readable
Is it possible to format my notification email that tells me a new row has been added to our sheet so that it looks more like the web form we use to submit our new requests? Right now the notification email just shows a condensed version of the new row, in a row format, which isn't very readable.
Thanks!
Comments
-
Travis Employee
Hi Nosbo, this isnt possible yet but we are tracking feedback for this request and I will add your vote for it!
-
Please add my vote for this also. My company would benefit from this enhancement as well. Thanks!
-
Travis Employee
Kelly - I added your vote as well!
-
Brad Jones ✭✭✭✭✭✭
I'm not sure if I'm on the right discussion for what I want, but I think it's close.
I have a master sheet with lots of rows and columns. Once a day the subscribed users get an update of the changes on the sheet. What they get is a MASSIVE sheet full of extraneous stuff. I have 50% of my sheet hidden for usabilities sake, but 100% of the sheet is shown in the notification and highlighted. All of the hidden tracking formulas and counting cells will update of course, but I don't want the user to have a comprehensive view of the whole sheet when they don't see it while interacting with the sheet.
This seems to work ok on the "Send Row" feature, as only the non-hidden rows are visible in the list.
Cheers
-
Joshua ✭
Please add my vote for this feature, also. I made the same request not too long ago, but it sounds like Smartsheet still isn't implementing the ability to reformat the way notifications are received.
I'm not a programmer, but the request seemed simple enough: we just want a way to select a Vertical layout instead of a Horizontal layout, and the exact option we're asking for is already available in the "Send Row" function.
Thank you.
-
Brad Jones ✭✭✭✭✭✭
Hello SS team,
Where are we with improving the notifications formatting?
The #1, most frequent, and most vocal complaint I get from my teams is regarding the format of these notifications. They look awful on a mobile phone, show hidden data, and seperate the useful information into three less useful piles: row changes, attachment changes, and comment changes.
If you have a sheet that 30 people are using, and you get a daily notification of those sheet changes, then what you have each morning is one super long email where you have to scroll up/down/up/down/up/down (ad nauseum) because you want to know about ALL the changes that happened to a row in one place. It does you no good to separate the cell changes from the coments and attachments - that's just silly. SS is about bringing information together, not splitting it up.
Block all the information about one row together, then move to the next row.
Thanks for supporting us SS. You are slower than my patience, but you do a good job.
-
Please add my vote to improve this. I have a form with a lot of columns and the notification is not readable on a mobile phone. Can you just add an option for the data to populate vertical instead of horizontal. At least they can scroll and see all the data. Scrolling left/right is not normal behavior with mobile
-
Please add my vote - We need to be able to make the notifictaion ledgeable or be able to send notifcations from a summary like report that is linked to the sheet.
-
Brad Jones ✭✭✭✭✭✭
Vertical vs Horizontal is not going to solve this for everyone. In fact, it would make our notifications even longer than before. My 'main sheet' is already 35columns wide. If we made it vertical it would mean that readers would wear out their thumb trying to scroll to the bottom of the email for the content.
-
Please add my vote to this as well! Having vertical notifications similar to the format when "sending" a row would be amazing. It is much easier to read and allows people receiving these notifications to read it more like a traditional email.
Cheers,
-
我可以添加一个投票能够定制移动电话ls are shown in the email notification. We have over 100 columns in our sheets so the email notifications are impossible to read. You can only get any use of the notification by entering something into the email subject or body copy. I'd like to be able to have the notification only show the row that was changed and the primary cell of that row.
-
Shaine Greenwood Employee
Hi Nick,
We've got a new way of submitting feedback to our Product team. Check out the announcement for more information on this:https://community.smartsheet.com/announcement/new-way-submit-your-feature-requests
-
Brad Jones ✭✭✭✭✭✭
Shaine,
Given the number of feature request posts that have been pasted with this "New way to submit feature requests" line, should I take it to mean that I must now go through all of my feature requests and submit them via this form again???
Some of my requests are a year old, and it would be cumbersome to go through the forum and try to find all of them.
-
Shaine Greenwood Employee
Brad—The Community team has definitely logged votes in past instances but we're no longer going to log future votes for a feature made only in the community.
I realize that you may have to speak your piece more than once if you want to share your ideas with the community, but this new process is the best way for our Product team to understand why you want a feature (what you'll use it for) and to have a means to contact you if they need to follow up with more questions.
-
Please add my vote for this and also can be customised the subject or content with data in the field.
Categories
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-27T02:16:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":24,"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-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":"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":24,"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":"