使用内容

找到答案,你的核心Smartsheet应用程序,添加ons和集成问题,在这里。

类别列表

Hi @Karen Bruer<\/a>,<\/p>

Neither from the dashboard view, nor from viewing the report directly can you hide or remove the column names.<\/p>

Looks like your report is on a dashboard. In that case, you can only remove the widget title. <\/p>

In reports you can change the Primary column name, but that's about it.<\/p>

All the best,<\/p>

-Ray<\/p>"},{"commentID":352300,"body":"

Thanks @Ray Lindstrom<\/a><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-25 15:50:10","updateUser":{"userID":128842,"name":"Karen Bruer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Karen%20Bruer","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5MPAuTrWZX4!elHDp9qhGX4!HMSKFvshvfI","dateLastActive":"2022-11-25T15:55:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}}},"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":98137,"type":"question","name":"Report not linking to line on source sheet","excerpt":"Hello, We have a number of sheets and use reports to prioritise work from these sheets. In our reports we have the source sheet column identified which links back to the sheet. It used to link to the exact line on the source sheet but for some reason now goes to the top of the sheet so we then have to search for it Any…","categoryID":321,"dateInserted":"2022-11-25T15:31:51+00:00","dateUpdated":null,"dateLastComment":"2022-11-25T15:31:51+00:00","insertUserID":93741,"insertUser":{"userID":93741,"name":"AndrewC","url":"https:\/\/community.smartsheet.com\/profile\/AndrewC","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jB9e48Qcxvo!3Afdv_xwBz4!8ALQbYPVpce","dateLastActive":"2022-11-25T17:22:20+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":93741,"lastUser":{"userID":93741,"name":"AndrewC","url":"https:\/\/community.smartsheet.com\/profile\/AndrewC","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jB9e48Qcxvo!3Afdv_xwBz4!8ALQbYPVpce","dateLastActive":"2022-11-25T17:22:20+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":14,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/98137\/report-not-linking-to-line-on-source-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98137\/report-not-linking-to-line-on-source-sheet","format":"Rich","lastPost":{"discussionID":98137,"name":"Report not linking to line on source sheet","url":"https:\/\/community.smartsheet.com\/discussion\/98137\/report-not-linking-to-line-on-source-sheet","dateInserted":"2022-11-25T15:31:51+00:00","insertUserID":93741,"insertUser":{"userID":93741,"name":"AndrewC","url":"https:\/\/community.smartsheet.com\/profile\/AndrewC","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jB9e48Qcxvo!3Afdv_xwBz4!8ALQbYPVpce","dateLastActive":"2022-11-25T17:22:20+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-25 18:12:36","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-11-25T18:11:10+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":98077,"type":"question","name":"Percent Complete Plan Formula","excerpt":"Smartsheet Community: I am Tracking Plan VS Actual and have a % Complete Formula to Track The Plan. However, My Formula is at 100% Complete for Plan, but the due date is 11\/28\/22. Therefore, it should be Calculating 100% Complete as of Today. Does anyone have any idea where in my formula is incorrect? % Complete (Plan):…","categoryID":321,"dateInserted":"2022-11-23T14:29:44+00:00","dateUpdated":null,"dateLastComment":"2022-11-25T15:31:14+00:00","insertUserID":148625,"insertUser":{"userID":148625,"name":"Kal","url":"https:\/\/community.smartsheet.com\/profile\/Kal","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-25T15:28:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":148625,"lastUser":{"userID":148625,"name":"Kal","url":"https:\/\/community.smartsheet.com\/profile\/Kal","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-25T15:28:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":47,"score":null,"hot":3338605258,"url":"https:\/\/community.smartsheet.com\/discussion\/98077\/percent-complete-plan-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98077\/percent-complete-plan-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":98077,"commentID":352295,"name":"Re: Percent Complete Plan Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/352295#Comment_352295","dateInserted":"2022-11-25T15:31:14+00:00","insertUserID":148625,"insertUser":{"userID":148625,"name":"Kal","url":"https:\/\/community.smartsheet.com\/profile\/Kal","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-25T15:28:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":4,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/A781BVQ42VBY\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"rejected","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":4,"name":"Rejected","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-25 18:12:46","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-11-25T18:11:10+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":98115,"type":"question","name":"Update Request Automation has stopped working","excerpt":"I have an automation set up to send an Update request for when a row changes, to an email address inputted on the row. It has been working for a while, and still works for most email addresses, but for some reason has now stopped working for just a few emails. Is there a reason for this? Settings have been checked and all…","categoryID":321,"dateInserted":"2022-11-24T15:52:13+00:00","dateUpdated":null,"dateLastComment":"2022-11-25T15:26:56+00:00","insertUserID":155306,"insertUser":{"userID":155306,"name":"Becky Slocombe","url":"https:\/\/community.smartsheet.com\/profile\/Becky%20Slocombe","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!A7P0B6rVBDI!hHi1Ia0k4qQ!S6wTEWDKCyk","dateLastActive":"2022-11-25T09:51:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-11-25T19:24:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":18,"score":null,"hot":3338695749,"url":"https:\/\/community.smartsheet.com\/discussion\/98115\/update-request-automation-has-stopped-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98115\/update-request-automation-has-stopped-working","format":"Rich","tagIDs":[334,446],"lastPost":{"discussionID":98115,"commentID":352293,"name":"Re: Update Request Automation has stopped working","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/352293#Comment_352293","dateInserted":"2022-11-25T15:26:56+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-11-25T19:24:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-11-25T15:26:56+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-25 15:26:56","updateUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-11-25T19:24:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}}},"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":334,"urlcode":"automations","name":"Automations"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}]},{"discussionID":84619,"type":"question","name":"Extracting time from a date field","excerpt":"Hi, I'm using Data Shuttle to import an Excel file that has a combined date\/time. Smartsheet\/Data Shuttle is recognizing the date, and bringing the field in as only the date. I've tried bringing it in to both date and text columns, same result. I've tried importing manually into Smartsheet (not using Data Shuttle) and same…","categoryID":321,"dateInserted":"2021-11-02T17:29:53+00:00","dateUpdated":null,"dateLastComment":"2022-11-25T15:07:41+00:00","insertUserID":120248,"insertUser":{"userID":120248,"name":"Terry Lewis","url":"https:\/\/community.smartsheet.com\/profile\/Terry%20Lewis","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hRdWISHE77Q!BGFXAeWyJfo!qnlZSsZK26P","dateLastActive":"2022-10-31T15:32:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":155318,"lastUser":{"userID":155318,"name":"NJCunliffe","url":"https:\/\/community.smartsheet.com\/profile\/NJCunliffe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-25T14:58:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":42,"score":null,"hot":3305266654,"url":"https:\/\/community.smartsheet.com\/discussion\/84619\/extracting-time-from-a-date-field","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/84619\/extracting-time-from-a-date-field","format":"Rich","lastPost":{"discussionID":84619,"commentID":352284,"name":"Re: Extracting time from a date field","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/352284#Comment_352284","dateInserted":"2022-11-25T15:07:41+00:00","insertUserID":155318,"insertUser":{"userID":155318,"name":"NJCunliffe","url":"https:\/\/community.smartsheet.com\/profile\/NJCunliffe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-25T14:58:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/PYTU3UW9MSGF\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-11-03T19:08:41+00:00","dateAnswered":"2021-11-03T16:37:43+00:00","acceptedAnswers":[{"commentID":309850,"body":"

Hi @Terry Lewis<\/a> <\/p>

Since Smartsheet does not have a Time function or column type, you would want to map this data to a Text\/Number column. In testing on my end, mapping this type of value to a Text\/Number column brought through the entire cell contents. <\/p>

If you're only seeing the Date come through when mapping to a Text\/Number column, would you be able to upload a copy of the file with dummy data that I could test with?<\/p>

Thanks!<\/p>

Genevieve<\/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":75870,"type":"question","name":"Printing Grouped Reports","excerpt":"I have a report that i have used the new grouping function on and i'm wanting to print it with the group headings but each time i print as pdf or export it only shows the standard cells, without the group headings, is this correct or is there something i'm missing?","categoryID":321,"dateInserted":"2021-02-07T19:56:46+00:00","dateUpdated":null,"dateLastComment":"2022-11-25T15:02:05+00:00","insertUserID":131710,"insertUser":{"userID":131710,"name":"J.H.W.","url":"https:\/\/community.smartsheet.com\/profile\/J.H.W.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-18T12:47:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":155325,"lastUser":{"userID":155325,"name":"amanda.wright","url":"https:\/\/community.smartsheet.com\/profile\/amanda.wright","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-25T14:58:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":52,"countViews":2815,"score":8,"hot":3282149931,"url":"https:\/\/community.smartsheet.com\/discussion\/75870\/printing-grouped-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75870\/printing-grouped-reports","format":"Rich","tagIDs":[265],"lastPost":{"discussionID":75870,"commentID":352281,"name":"Re: Printing Grouped Reports","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/352281#Comment_352281","dateInserted":"2022-11-25T15:02:05+00:00","insertUserID":155325,"insertUser":{"userID":155325,"name":"amanda.wright","url":"https:\/\/community.smartsheet.com\/profile\/amanda.wright","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-25T14:58:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-02-08T04:55:16+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-07-11 14:49:05","updateUser":{"userID":149942,"name":"Gerardo Saenz","url":"https:\/\/community.smartsheet.com\/profile\/Gerardo%20Saenz","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AFdZucrwCNWznlII9OSel_5xsT2_ViTunqzNLEE-h5st=s96-c","dateLastActive":"2022-08-03T20:18:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":8},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"}]},{"discussionID":98013,"type":"question","name":"Setting an entire Project Sheet to On Hold","excerpt":"Hi all, I'm sure someone has encountered this but I'm curious if anyone has done anything with setting an entire project \"On Hold\" so that it reflects in the rollup sheets\/dashboards. For reference, we are using the PMO template to base our projects off of. What we would like to be able to do is put a new row in at the…","categoryID":321,"dateInserted":"2022-11-21T19:51:29+00:00","dateUpdated":null,"dateLastComment":"2022-11-25T13:33:39+00:00","insertUserID":146258,"insertUser":{"userID":146258,"name":"dhall","url":"https:\/\/community.smartsheet.com\/profile\/dhall","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-21T19:51:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":146258,"lastUser":{"userID":146258,"name":"dhall","url":"https:\/\/community.smartsheet.com\/profile\/dhall","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-21T19:51:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":32,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/98013\/setting-an-entire-project-sheet-to-on-hold","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98013\/setting-an-entire-project-sheet-to-on-hold","format":"Rich","tagIDs":[215,254,334],"lastPost":{"discussionID":98013,"name":"Setting an entire Project Sheet to On Hold","url":"https:\/\/community.smartsheet.com\/discussion\/98013\/setting-an-entire-project-sheet-to-on-hold","dateInserted":"2022-11-25T13:33:39+00:00","insertUserID":146258,"insertUser":{"userID":146258,"name":"dhall","url":"https:\/\/community.smartsheet.com\/profile\/dhall","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-21T19:51:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","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":215,"urlcode":"Templates","name":"Templates"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":98060,"type":"question","name":"Approval Requests summary from HOME tab","excerpt":"Hi Did smartsheet remove the approval requests summary from the HOME tab? This feature provided tracking of all the requests sent by the sheet owner and a list of all pending requests that need to be approved by the current user. Would you know whether Smartheet removed this feature or moved it somewhere else? I appreciate…","categoryID":321,"dateInserted":"2022-11-22T22:59:22+00:00","dateUpdated":null,"dateLastComment":"2022-11-25T13:18:21+00:00","insertUserID":126193,"insertUser":{"userID":126193,"name":"Rahul Patel","url":"https:\/\/community.smartsheet.com\/profile\/Rahul%20Patel","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!koFV_7dOevo!k0tVvxdye7o!RKuOltBclF4","dateLastActive":"2022-11-24T23:24:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-11-25T18:11:10+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":38,"score":null,"hot":3338542063,"url":"https:\/\/community.smartsheet.com\/discussion\/98060\/approval-requests-summary-from-home-tab","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98060\/approval-requests-summary-from-home-tab","format":"Rich","tagIDs":[451],"lastPost":{"discussionID":98060,"commentID":352277,"name":"Re: Approval Requests summary from HOME tab","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/352277#Comment_352277","dateInserted":"2022-11-25T13:18:21+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-11-25T18:11:10+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-11-24T12:16:38+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-24 12:16:38","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-11-25T18:11:10+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":451,"urlcode":"home-and-navigation","name":"Home and Navigation"}]}],"title":"Recent Discussions","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Hi @Karen Bruer<\/a>,<\/p>

Neither from the dashboard view, nor from viewing the report directly can you hide or remove the column names.<\/p>

Looks like your report is on a dashboard. In that case, you can only remove the widget title. <\/p>

In reports you can change the Primary column name, but that's about it.<\/p>

All the best,<\/p>

-Ray<\/p>"},{"commentID":352300,"body":"

Thanks @Ray Lindstrom<\/a><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-25 15:50:10","updateUser":{"userID":128842,"name":"Karen Bruer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Karen%20Bruer","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5MPAuTrWZX4!elHDp9qhGX4!HMSKFvshvfI","dateLastActive":"2022-11-25T15:55:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}}},"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":98122,"type":"question","name":"Dashboard unwanted white space","excerpt":"In my dashboard I've created a number of Metrics Widgets from a series of columns in my sheet, and the widget has a wide blank section after the metrics. How do I delete this?","categoryID":321,"dateInserted":"2022-11-24T19:44:10+00:00","dateUpdated":null,"dateLastComment":"2022-11-24T22:38:31+00:00","insertUserID":128842,"insertUser":{"userID":128842,"name":"Karen Bruer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Karen%20Bruer","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5MPAuTrWZX4!elHDp9qhGX4!HMSKFvshvfI","dateLastActive":"2022-11-25T15:55:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":142964,"lastUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/LBB70FV9GP52\/nY1AJCGUNDHDC.jpg","dateLastActive":"2022-11-25T15:37:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":30,"score":null,"hot":3338649161,"url":"https:\/\/community.smartsheet.com\/discussion\/98122\/dashboard-unwanted-white-space","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98122\/dashboard-unwanted-white-space","format":"Rich","lastPost":{"discussionID":98122,"commentID":352250,"name":"Re: Dashboard unwanted white space","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/352250#Comment_352250","dateInserted":"2022-11-24T22:38:31+00:00","insertUserID":142964,"insertUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/LBB70FV9GP52\/nY1AJCGUNDHDC.jpg","dateLastActive":"2022-11-25T15:37:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/YHMJW8Y7TOAD\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-24T23:03:53+00:00","dateAnswered":"2022-11-24T22:38:31+00:00","acceptedAnswers":[{"commentID":352250,"body":"

Hi @Karen Bruer<\/a>,<\/p>

Click and drag this blue box to the left until the widget is only as wide as you need to display what is there.<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

Hope this is what you were looking to do.<\/p>

All the best,<\/p>

-Ray<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-24 23:03:53","updateUser":{"userID":128842,"name":"Karen Bruer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Karen%20Bruer","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5MPAuTrWZX4!elHDp9qhGX4!HMSKFvshvfI","dateLastActive":"2022-11-25T15:55:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}}},"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":98098,"type":"question","name":"What am I doing wrong in this IF formula?","excerpt":"I need the total score % reflected in the column, unless the score for Q3 is 0. =IF(Q3 Score = 0, 0, {=SUM([Q1 Score]@row:[Q10 score]@row)}) What am I missing?","categoryID":321,"dateInserted":"2022-11-23T19:58:17+00:00","dateUpdated":null,"dateLastComment":"2022-11-23T20:14:12+00:00","insertUserID":155289,"insertUser":{"userID":155289,"name":"Nickit","url":"https:\/\/community.smartsheet.com\/profile\/Nickit","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-23T21:06:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":127476,"lastUser":{"userID":127476,"name":"Leibel Shuchat","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Leibel%20Shuchat","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-24T16:20:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":39,"score":null,"hot":3338468549,"url":"https:\/\/community.smartsheet.com\/discussion\/98098\/what-am-i-doing-wrong-in-this-if-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98098\/what-am-i-doing-wrong-in-this-if-formula","format":"Rich","lastPost":{"discussionID":98098,"commentID":352148,"name":"Re: What am I doing wrong in this IF formula?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/352148#Comment_352148","dateInserted":"2022-11-23T20:14:12+00:00","insertUserID":127476,"insertUser":{"userID":127476,"name":"Leibel Shuchat","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Leibel%20Shuchat","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-24T16:20:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-23T21:08:55+00:00","dateAnswered":"2022-11-23T20:14:12+00:00","acceptedAnswers":[{"commentID":352148,"body":"

@Nickit<\/a> <\/p>

=IF([Q3 Score]@row = 0, 0, SUM([Q1 Score]@row:[Q10 score]@row))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-23 21:08:55","updateUser":{"userID":155289,"name":"Nickit","url":"https:\/\/community.smartsheet.com\/profile\/Nickit","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-23T21:06:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">