Per the 1.5 years of queries being made, I believe there is suitable interest from the Community that Smartsheet provides the basic functionality of being able to print a Grouped Report. The system currently reverts the Report to a basic Sheet when Print is selected. This is not suitable or acceptable.
We are working on improving the experience for reporting including how to improve print/export options as part of that long-term plan. In the mean time you can add your grouped report to a dashboard, which then can print and export with the included groupings.
I have also logged a complaint about this issue and would like to see a resolution. Ability to print on paper and/or PDF while maintaining formatting seems like a fundamental feature.
The ability to print a report that maintains the grouping is also critical to the automated scheduling feature for reports. I have a report that my CEO loves using the grouping feature in Smartsheet but when I schedule this report to be automatically sent (as a pdf or excel) the report my CEO receives has reverted to a basic sheet. Very frustrating and disappointing because for a brief moment I was a hero delivering a great-looking report and the next I had to say but you can't export it looking like this.
We need to schedule production in the factory and are using Smartsheet to distribute the information. The grouped report shows the schedule by production line, however the printed version looses this advantage and becomes difficult to read. As well as using the online version, we need to print off the sheet and it is disappointing that the printed version is useless for our purposes at the moment. The workaround we are doing at the moment is to transfer the data into an excel sheet and manually recreate the schedule by production line.
我还要求这个特性。我需要一个ble to have clear, concise reports with summaries for upper level management. But the only way they can see it now is by going into the report. I need it to send automatically though. And that only produces an excel or PDF without the necessary groupings.
Groupings are essentially worthless since you cannot export or print them. Also, I would like to see pivot tables added to the basic subscription. Smartsheet is branded as better than spreadsheets. Well - spreadsheets include pivot tables. Smartsheet could be more powerful with some simple enhancements.
The video within Smartsheet Help infers that Reports can be scheduled to be sent via PDF - whilst it doesn't explicitly state that Grouping formats remain, it is most likely assumed by the user that it would be. Perhaps it was thought this functionality would be available from the get-go.
@Genevieve P.- any insight when this request (or any others nominated) will migrate over to the On Radar | On Roadmap | Coming Soon! status? Currently, there are no topics within these three statuses.
Do you have any updates on the resolution of this issue? As@MPAdminhas noted, the Dashboard option really isn't a viable solution. Are you able to give any time-based estimates on when Smartsheet will be looking to deploy an update and provide users with the ability to print what they see on their screen? Is Smartsheet actively looking at this item? I get the feeling that Smartsheet is treating this issue as an "improvement", rather than what it is - a bug - which is preventing organisations/teams/individuals from delivering their work as intended.
2023-05-27T05:38:41.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":106863,"type":"idea","name":"Add friends\/coworkers within the community","excerpt":"I would love to be able to add and follow friends within this community- is this already possible? Does this currently exist?","categoryID":348,"dateInserted":"2023-06-24T00:04:38+00:00","dateUpdated":null,"dateLastComment":"2023-06-26T08:41:17+00:00","insertUserID":146478,"insertUser":{"userID":146478,"name":"malbers","title":"","url":"https:\/\/community.smartsheet.com\/profile\/malbers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/UWZGZGP18PK8\/nZFAGSNFMCT3V.jpg","dateLastActive":"2023-06-26T17:54:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-26T16:24:30+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":3,"hot":3375335455,"url":"https:\/\/community.smartsheet.com\/discussion\/106863\/add-friends-coworkers-within-the-community","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106863\/add-friends-coworkers-within-the-community","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106863,"commentID":382214,"name":"Re: Add friends\/coworkers within the community","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382214#Comment_382214","dateInserted":"2023-06-26T08:41:17+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-26T16:24:30+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Community Platform Feedback","url":"https:\/\/community.smartsheet.com\/categories\/community-platform-feedback"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":348,"name":"Community Platform Feedback","url":"https:\/\/community.smartsheet.com\/categories\/community-platform-feedback","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":3}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106789,"type":"idea","name":"Limiting attachment access by license","excerpt":"I have run into a situation where I have confidential documents attached to a worksheet row that need to be available to certain personnel. These same worksheet rows are also accessed by personnel that should NOT have access to these documents. I already have hidden the attachment column, and several other columns that…","categoryID":349,"dateInserted":"2023-06-22T17:27:25+00:00","dateUpdated":"2023-06-22T17:28:26+00:00","dateLastComment":"2023-06-26T18:06:18+00:00","insertUserID":162646,"insertUser":{"userID":162646,"name":"karlj","title":"Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/karlj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-22T17:27:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162646,"lastUserID":161565,"lastUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-26T18:59:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":2,"hot":3375258823,"url":"https:\/\/community.smartsheet.com\/discussion\/106789\/limiting-attachment-access-by-license","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106789\/limiting-attachment-access-by-license","format":"Rich","tagIDs":[268,363],"lastPost":{"discussionID":106789,"commentID":382382,"name":"Re: Limiting attachment access by license","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382382#Comment_382382","dateInserted":"2023-06-26T18:06:18+00:00","insertUserID":161565,"insertUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-26T18:59:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106787,"type":"idea","name":"Print a Smartsheet form- to MS Word and PDF","excerpt":"It would be nice to have the ability to print a Smartsheet form created to MS Word and PDF (form view layout, not smartsheet view layout) after someone has submitted the form.","categoryID":349,"dateInserted":"2023-06-22T16:46:26+00:00","dateUpdated":"2023-06-22T16:52:12+00:00","dateLastComment":"2023-06-26T18:34:44+00:00","insertUserID":162643,"insertUser":{"userID":162643,"name":"TomGSB","url":"https:\/\/community.smartsheet.com\/profile\/TomGSB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T00:12:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":161565,"lastUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-26T18:59:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":14,"score":3,"hot":3375258370,"url":"https:\/\/community.smartsheet.com\/discussion\/106787\/print-a-smartsheet-form-to-ms-word-and-pdf","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106787\/print-a-smartsheet-form-to-ms-word-and-pdf","format":"Rich","tagIDs":[204,363],"lastPost":{"discussionID":106787,"commentID":382386,"name":"Re: Print a Smartsheet form- to MS Word and PDF","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382386#Comment_382386","dateInserted":"2023-06-26T18:34:44+00:00","insertUserID":161565,"insertUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-26T18:59:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":3}],"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-05-27T05%3A38%3A41%2B00%3A00&type%5B0%5D=Idea&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":138,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">