Removing the "Comments" tab from exported Excel reports
Hello, everyone! I have an automated Report that exports as an Excel file attachment to a team leader every week. He uses this report to upload info into a different system (not project management, a totally different thing). Each report comes with the report on one worksheet tab and a second worksheet tab called "Comments."
We don't need the "Comments" worksheet. Is there a setting I'm overlooking in the Report settings to remove this?
I appreciate your collective insight!
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist | Process Improvement Enthusiast
Answers
-
Paul Newcome ✭✭✭✭✭✭I haven't come across any settings for this, but it would be nice if we could select this.
Have you checked the Product Ideas tab for it yet?
Categories
=IF([Fully Certified]@row = \"Yes\", MAX([Train Date - Blower]@row, [Train Date - Broom]@row, [Train Date - Chem]@row), \"//www.santa-greenland.com/community/discussion/109418/\")<\/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":[]},{"discussionID":110767,"type":"question","name":"PDF Icon \/ Thumbnail in the row?","excerpt":"Hi, I'm sure its a big use of smart sheet, I use various registers to store documents especially drawings. Each row is a drawing or document, if there are different Issues I use the upload new version. There are the Ref#, Issue#, description and drawn date columns etc. The drawing is a pdf attachment. However you can not…","snippet":"Hi, I'm sure its a big use of smart sheet, I use various registers to store documents especially drawings. Each row is a drawing or document, if there are different Issues I use…","categoryID":321,"dateInserted":"2023-09-26T10:55:25+00:00","dateUpdated":"2023-09-26T11:49:30+00:00","dateLastComment":"2023-09-28T11:22:19+00:00","insertUserID":138065,"insertUser":{"userID":138065,"name":"Michael Batt","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Batt","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T13:27:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"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-09-28T18:13:13+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":23,"score":null,"hot":3391626464,"url":"https:\/\/community.smartsheet.com\/discussion\/110767\/pdf-icon-thumbnail-in-the-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110767\/pdf-icon-thumbnail-in-the-row","format":"Rich","lastPost":{"discussionID":110767,"commentID":397383,"name":"Re: PDF Icon \/ Thumbnail in the row?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397383#Comment_397383","dateInserted":"2023-09-28T11:22:19+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-09-28T18:13:13+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-28T12:05:59+00:00","dateAnswered":"2023-09-28T11:22:19+00:00","acceptedAnswers":[{"commentID":397383,"body":"
![\"Screenshot](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/FQIXXT6IRJ6S\/screenshot-2023-09-28-at-12-18-26.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
