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.
Feature Request: Row Summary Documents
Our business utilizes Smartsheet in so many ways. One feature that continually wish Smartsheet had is what I call a "Row Summary Document". This feature would essentially mimic the Form builder already contained in Smartsheet, however it would be in reverse. The form would actually be populated based on an already populated row. Therefore a user could summarize or print a row in a logical, page summary format for easy sharing. Another program or function similar would be mail merge, in which a spreadsheet is converted into a form.
I could use this functionality everyday and it would open up the tool for even more uses!
Anyone agree?
Comments
-
Travis EmployeeHi Medic, check out our Google integration -Smartsheet Merge
Smartsheet Merge allows you to send row data to Google Docs and create a custom format to display the data.
I think this is close to what you are looking for!
From the integration page:
"Smartsheet Merge gives you the power to merge that data into a custom Google Doc template to create multiple Google documents or PDFs in a snap."
-
I would really like this functionality as well! I'll check out Smartsheet Merge.
Categories
I hope you're well and safe!<\/p>
- Have you scrolled all the way down to the bottom of the sheet?<\/li>
- Also, have you checked the Activity Log so the submission is added to the sheet?<\/li><\/ul>
Did that work\/help? <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic week!<\/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":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":204,"urlcode":"Forms","name":"Forms"}]},{"discussionID":107831,"type":"question","name":"How to only edit a cell if it is negative","excerpt":"I have a formula that sometimes will pull a negative number. What would the formula be to multiply by -1 if negative?","snippet":"I have a formula that sometimes will pull a negative number. What would the formula be to multiply by -1 if negative?","categoryID":322,"dateInserted":"2023-07-20T01:52:32+00:00","dateUpdated":"2023-07-20T02:06:37+00:00","dateLastComment":"2023-07-20T11:52:39+00:00","insertUserID":162138,"insertUser":{"userID":162138,"name":"Louis.Smith","url":"https:\/\/community.smartsheet.com\/profile\/Louis.Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T12:02:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":162138,"lastUserID":162138,"lastUser":{"userID":162138,"name":"Louis.Smith","url":"https:\/\/community.smartsheet.com\/profile\/Louis.Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T12:02:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":20,"score":null,"hot":3379673111,"url":"https:\/\/community.smartsheet.com\/discussion\/107831\/how-to-only-edit-a-cell-if-it-is-negative","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107831\/how-to-only-edit-a-cell-if-it-is-negative","format":"Rich","lastPost":{"discussionID":107831,"commentID":386120,"name":"Re: How to only edit a cell if it is negative","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386120#Comment_386120","dateInserted":"2023-07-20T11:52:39+00:00","insertUserID":162138,"insertUser":{"userID":162138,"name":"Louis.Smith","url":"https:\/\/community.smartsheet.com\/profile\/Louis.Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T12:02:38+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/N6K1YLWHGSYF\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-20T11:52:23+00:00","dateAnswered":"2023-07-20T03:38:20+00:00","acceptedAnswers":[{"commentID":386101,"body":"
You can just wrap the entire formula you are using in ABS() to return the absolute value.<\/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":107785,"type":"question","name":"Formula Needed","excerpt":"Hi Smartsheet Team, I am looking for help with a formula: I have a column \"Schedule Health\" that has RYG Balls I am wanting this to change color based on certain criteria from 3 other columns \"Status\", \"Start Date\", \"End Date\". Ball is GREEN if \"Start Date\" is 7 days from today (ie project has not started yet) Ball is…","snippet":"Hi Smartsheet Team, I am looking for help with a formula: I have a column \"Schedule Health\" that has RYG Balls I am wanting this to change color based on certain criteria from 3…","categoryID":322,"dateInserted":"2023-07-19T12:29:48+00:00","dateUpdated":null,"dateLastComment":"2023-07-20T12:21:42+00:00","insertUserID":163658,"insertUser":{"userID":163658,"name":"Rod Sanderson","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Rod%20Sanderson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T12:20:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163658,"lastUser":{"userID":163658,"name":"Rod Sanderson","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Rod%20Sanderson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T12:20:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":43,"score":null,"hot":3379627890,"url":"https:\/\/community.smartsheet.com\/discussion\/107785\/formula-needed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107785\/formula-needed","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107785,"commentID":386124,"name":"Re: Formula Needed","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386124#Comment_386124","dateInserted":"2023-07-20T12:21:42+00:00","insertUserID":163658,"insertUser":{"userID":163658,"name":"Rod Sanderson","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Rod%20Sanderson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-20T12:20:17+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-07-19T15:43:55+00:00","dateAnswered":"2023-07-19T13:51:54+00:00","acceptedAnswers":[{"commentID":385913,"body":"
