Sign in to submit new ideas and vote
Get Started

Print a Smartsheet form- to MS Word and PDF

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.

Tags:
5
Up
5 votes

Idea Submitted·Last Updated

Comments

  • Some workarounds I found for not printing a form submission directly:

    You can print a Smartsheet row to PDF using the row's right-click menu, Print. (For a PDF file use a "printer" like Save as PDF or Microsoft Print to PDF). That method creates a document with just the one row's information, it looks like a printout of a two-column table (field name and the row's answer for that field). You can hide columns and tell it not to print hidden columns, but otherwise it does print all fields without an option to pick and choose specific ones.

    You can create a more customized PDF attachment to print by using the "Generate Document" option in sheet automations/workflows. You have to upload a PDF with fillable fields, map the relevant sheet fields to the fillable fields, and then the automation will make a filled-in PDF for each row it's triggered on, and add the filled-in PDF as an Attachment on the row. Then you would need to print the attachment. So you could make a custom PDF on the row that only shows the completed form fields. I don't think there's a way to generate a Word doc on each row.https://help.smartsheet.com/articles/2482492-build-workflow-automate-document-generation

    I've also heard of people using the "send me a copy" email or customized Alert emails to print the email to PDF.

  • I agree this would be a nice feature. Our current workaround is to have the form sent to an internal email and then someone has to take the attachment from the email and attach it to the coordinating row. We use a form to do a site assessment and we want the compiled assessment as an attachment to the homeowner's row.

2023-06-01T10:49:35.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":107133,"type":"idea","name":"Replying to Comment via email","excerpt":"When I send a comment using @ functionality from a Sheet, I would like reply comments to come into the Sheet. In other words, the recipient should be able to simply use \"reply\" via Outlook to send a reply, rather than needing to log into the Sheet to reply. I have used SS for at least 3 years, and that was always standard…","snippet":"When I send a comment using @ functionality from a Sheet, I would like reply comments to come into the Sheet. In other words, the recipient should be able to simply use \"reply\"…","categoryID":349,"dateInserted":"2023-06-30T12:37:38+00:00","dateUpdated":null,"dateLastComment":"2023-06-30T14:40:16+00:00","insertUserID":163041,"insertUser":{"userID":163041,"name":"Cynthia FUrlong","title":"Head of Sales Execution","url":"https:\/\/community.smartsheet.com\/profile\/Cynthia%20FUrlong","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T12:37:40+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-30T20:11:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":1,"hot":3376265574,"url":"https:\/\/community.smartsheet.com\/discussion\/107133\/replying-to-comment-via-email","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107133\/replying-to-comment-via-email","format":"Rich","tagIDs":[363,441],"lastPost":{"discussionID":107133,"commentID":383330,"name":"Re: Replying to Comment via email","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383330#Comment_383330","dateInserted":"2023-06-30T14:40:16+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-30T20:11:27+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":"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":1}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"}]},{"discussionID":107060,"type":"idea","name":"Tabbing through \"pages\" in form","excerpt":"When having clients\/customers\/employees fill out a form, it would be helpful to break the form down into \"pages\". This would allow the breakout of specific data sets from other information being collected.","snippet":"When having clients\/customers\/employees fill out a form, it would be helpful to break the form down into \"pages\". This would allow the breakout of specific data sets from other…","categoryID":349,"dateInserted":"2023-06-28T21:15:07+00:00","dateUpdated":"2023-06-28T21:15:23+00:00","dateLastComment":"2023-06-29T17:52:36+00:00","insertUserID":80376,"insertUser":{"userID":80376,"name":"brandi.meyer80376","url":"https:\/\/community.smartsheet.com\/profile\/brandi.meyer80376","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-29T18:10:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":80376,"lastUserID":160129,"lastUser":{"userID":160129,"name":"vdemattei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/vdemattei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-29T19:41:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":53,"score":5,"hot":3376050163,"url":"https:\/\/community.smartsheet.com\/discussion\/107060\/tabbing-through-pages-in-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107060\/tabbing-through-pages-in-form","format":"Rich","tagIDs":[204,363],"lastPost":{"discussionID":107060,"commentID":383171,"name":"Re: Tabbing through \"pages\" in form","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383171#Comment_383171","dateInserted":"2023-06-29T17:52:36+00:00","insertUserID":160129,"insertUser":{"userID":160129,"name":"vdemattei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/vdemattei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-29T19:41:04+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":5}],"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106980,"type":"idea","name":"Ability to Find & Replace text in Formulas","excerpt":"Hi Team, I am aware that this functionality isn't currently available. But, as someone who works on rows & rows of data every day, replacing values in a formula using the Find & Replace feature is extremely helpful and time-saving. As I type this, I have the daunting task of going back to my sheet on SmartSheets and…","snippet":"Hi Team, I am aware that this functionality isn't currently available. But, as someone who works on rows & rows of data every day, replacing values in a formula using the Find &…","categoryID":349,"dateInserted":"2023-06-27T21:44:51+00:00","dateUpdated":null,"dateLastComment":"2023-06-30T00:09:35+00:00","insertUserID":160498,"insertUser":{"userID":160498,"name":"svenu","title":"Sowmya","url":"https:\/\/community.smartsheet.com\/profile\/svenu","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/DCMMVCYWQVDW\/n8MOHGOMZQ316.jpg","dateLastActive":"2023-06-30T01:49:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":163029,"lastUser":{"userID":163029,"name":"Shonnify","title":"Payroll Tax Manager","url":"https:\/\/community.smartsheet.com\/profile\/Shonnify","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3dDW_y9sleY!!OlNA9rJUxAN","dateLastActive":"2023-06-30T00:17:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":32,"score":2,"hot":3375987266,"url":"https:\/\/community.smartsheet.com\/discussion\/106980\/ability-to-find-replace-text-in-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106980\/ability-to-find-replace-text-in-formulas","format":"Rich","tagIDs":[254,363],"lastPost":{"discussionID":106980,"commentID":383244,"name":"Re: Ability to Find & Replace text in Formulas","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383244#Comment_383244","dateInserted":"2023-06-30T00:09:35+00:00","insertUserID":163029,"insertUser":{"userID":163029,"name":"Shonnify","title":"Payroll Tax Manager","url":"https:\/\/community.smartsheet.com\/profile\/Shonnify","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3dDW_y9sleY!!OlNA9rJUxAN","dateLastActive":"2023-06-30T00:17:11+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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-06-01T10%3A49%3A35%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":145,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">