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?
Come see me at ENGAGE 2023! I have "Happy to help️" buttons!
If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.
Categories
First, do a list of all of the groups, find the groups and their IDs, and then create a request to add your user to the respective group.<\/p>
Ryan<\/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":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User Management"}]},{"discussionID":110515,"type":"question","name":"How do I add text to a formula","excerpt":"My current formula below works, and returns the value, 25%. But I want to add specific text to the value returned. So it should read, 25% - Milestone 1, or Milestone 1 - 25% =INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0)) Thanks.","snippet":"My current formula below works, and returns the value, 25%. But I want to add specific text to the value returned. So it should read, 25% - Milestone 1, or Milestone 1 - 25%…","categoryID":321,"dateInserted":"2023-09-20T16:52:32+00:00","dateUpdated":null,"dateLastComment":"2023-09-20T17:33:32+00:00","insertUserID":159073,"insertUser":{"userID":159073,"name":"SJTA","url":"https:\/\/community.smartsheet.com\/profile\/SJTA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-25T17:36:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":159073,"lastUser":{"userID":159073,"name":"SJTA","url":"https:\/\/community.smartsheet.com\/profile\/SJTA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-25T17:36:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":50,"score":null,"hot":3390461164,"url":"https:\/\/community.smartsheet.com\/discussion\/110515\/how-do-i-add-text-to-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110515\/how-do-i-add-text-to-a-formula","format":"Rich","tagIDs":[219,254],"lastPost":{"discussionID":110515,"commentID":396248,"name":"Re: How do I add text to a formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/396248#Comment_396248","dateInserted":"2023-09-20T17:33:32+00:00","insertUserID":159073,"insertUser":{"userID":159073,"name":"SJTA","url":"https:\/\/community.smartsheet.com\/profile\/SJTA","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-25T17:36:19+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-20T17:32:18+00:00","dateAnswered":"2023-09-20T17:27:12+00:00","acceptedAnswers":[{"commentID":396247,"body":" Just add the text you want in quotes, than a plus sign, than the formula text.<\/p> =\"Milestone 1 - \" + INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0)) <\/p> Or...<\/p> =INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0)) + \" - Milestone 1\"<\/p> You can see an explanation of a similar use case in this video https:\/\/youtu.be\/g9eap8EjFTI?t=272<\/a><\/p> Dan Palenchar | <\/strong>School of Sheets Solutions Consulting<\/a> (Smartsheet Aligned Gold Partner)<\/p> Smartsheet Consulting Inquiries: schoolofsheets.com\/workwithus<\/a><\/p> Smartsheet Tutorial Videos: schoolofsheets.com\/youtube<\/a><\/p>
![\"Email](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/YLZSWDRJUALA\/email-signature-logo.png\"){kind=logo}
<\/img><\/a>\n <\/div>\n<\/div>\n
