使用内容
类别列表
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":"
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":"
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/SM948AC1Q1V6\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\nHope 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":"
