报告

work group. The user is responsible for adding the new sheet to the master report. Beyond that, I can't ask uses to create links or other…","categoryID":318,"dateInserted":"2016-08-16T09:24:27+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-17T15:01:14+00:00","insertUserID":3399,"insertUser":{"userID":3399,"name":"Jeremy Myers","url":"https:\/\/community.smartsheet.com\/profile\/Jeremy%20Myers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-03-23T12:16:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":2677,"lastUser":{"userID":2677,"name":"Kennedy Stomps","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kennedy%20Stomps","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/5d\/7b\/n5d7b4f0582903f4af0de71e9360f57fa.jpg","dateLastActive":"2019-11-15T14:32:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/5826\/rollup-reporting-escrow-system","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5826\/rollup-reporting-escrow-system","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":266,"urlcode":"Real Estate","name":"Real Estate"}],"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}]},{"discussionID":5771,"type":"discussion","name":"Sights Dashboard Feedback from Power User","excerpt":"Hi there, not sure where to put in my feedback for Sights but I think it's a great tool but has the potential to really be so much more powerful for business users. I feel like I get stopped at ideas due to lack of features. Here are some ideas I hope you can add: - Export to PDF: we use the dashboard as sort of a…","categoryID":318,"dateInserted":"2016-08-10T10:07:57+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-16T13:31:53+00:00","insertUserID":7877,"insertUser":{"userID":7877,"name":"Crystal C","url":"https:\/\/community.smartsheet.com\/profile\/Crystal%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-10T10:01:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":7928,"lastUser":{"userID":7928,"name":"B. Edelstein","url":"https:\/\/community.smartsheet.com\/profile\/B.%20Edelstein","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-15T17:36:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":7,"countViews":23,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/5771\/sights-dashboard-feedback-from-power-user","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5771\/sights-dashboard-feedback-from-power-user","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}],"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}]},{"discussionID":5801,"type":"discussion","name":"Linking cells based on matching criteria","excerpt":"I have two sheets, both sheets have a row of column IDs, I would like to dynamically match the column ID from one sheet to the other sheet and then update a row. Similar to the new Lookup fucntion that was recently released but across two sheets. Has anyone developed a solution for this. My only option is to manually link…","categoryID":318,"dateInserted":"2016-08-11T19:32:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-15T15:48:51+00:00","insertUserID":7907,"insertUser":{"userID":7907,"name":"vjs7212","url":"https:\/\/community.smartsheet.com\/profile\/vjs7212","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-11T19:28:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":2677,"lastUser":{"userID":2677,"name":"Kennedy Stomps","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kennedy%20Stomps","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/5d\/7b\/n5d7b4f0582903f4af0de71e9360f57fa.jpg","dateLastActive":"2019-11-15T14:32:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":45,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/5801\/linking-cells-based-on-matching-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5801\/linking-cells-based-on-matching-criteria","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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}]},{"discussionID":5812,"type":"discussion","name":"Report is pulling correct results, but cells are blank","excerpt":"I have a set of project sheets that all share the same basic layout and format, AND also have all the same sharing permissions -- specifically, I am the owner of all of them. I'm trying to generate a report that shows me all sheets with an End Date in the future for a specific task \/ row in the sheet. The report seems to…","categoryID":318,"dateInserted":"2016-08-12T16:44:26+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-15T12:18:47+00:00","insertUserID":7843,"insertUser":{"userID":7843,"name":"Ian Schumann","url":"https:\/\/community.smartsheet.com\/profile\/Ian%20Schumann","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-05-04T16:34:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":7843,"lastUser":{"userID":7843,"name":"Ian Schumann","url":"https:\/\/community.smartsheet.com\/profile\/Ian%20Schumann","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-05-04T16:34:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":10,"countViews":298,"score":null,"hot":10,"url":"https:\/\/community.smartsheet.com\/discussion\/5812\/report-is-pulling-correct-results-but-cells-are-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5812\/report-is-pulling-correct-results-but-cells-are-blank","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":5800,"type":"discussion","name":"Creating a report, Not able to select column that exsists on sheet.","excerpt":"Hello, I use the same sheet frequently and change the title\/calendar to fit the need of the project. I also use the same report, and generally just change the sheet the search is restricted to in order to generate calendars for sub contractors for the specific project. However, I'm having a strange error. I'm trying to…","categoryID":318,"dateInserted":"2016-08-11T18:46:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-15T12:02:10+00:00","insertUserID":7904,"insertUser":{"userID":7904,"name":"Jesse Pittman","url":"https:\/\/community.smartsheet.com\/profile\/Jesse%20Pittman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-11T18:41:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":2677,"lastUser":{"userID":2677,"name":"Kennedy Stomps","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kennedy%20Stomps","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/5d\/7b\/n5d7b4f0582903f4af0de71e9360f57fa.jpg","dateLastActive":"2019-11-15T14:32:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":34,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/5800\/creating-a-report-not-able-to-select-column-that-exsists-on-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5800\/creating-a-report-not-able-to-select-column-that-exsists-on-sheet","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":265,"urlcode":"Reports","name":"Reports"}],"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}]},{"discussionID":5786,"type":"discussion","name":"Apply formulas to data aggregated in a report","excerpt":"So we've just started using smartsheet to track hours used for different projects. Each person gets one individual sheet to fill in. Once a week a report extracting the hours from the last 7 days is extracted and sent to the people keeping track of the mother organization. However, as a manager I'd like to keep track of…","categoryID":318,"dateInserted":"2016-08-11T08:30:08+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-11T15:35:52+00:00","insertUserID":5758,"insertUser":{"userID":5758,"name":"Christopher Grinde","url":"https:\/\/community.smartsheet.com\/profile\/Christopher%20Grinde","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-18T04:35:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":279,"lastUser":{"userID":279,"name":"Kara Lumley","url":"https:\/\/community.smartsheet.com\/profile\/Kara%20Lumley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/95\/4e\/n954e10e9b436e9acd6f195bdf2312f07.jpg","dateLastActive":"2020-11-10T15:44:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":12,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/5786\/apply-formulas-to-data-aggregated-in-a-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5786\/apply-formulas-to-data-aggregated-in-a-report","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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}]},{"discussionID":5780,"type":"discussion","name":"Advanced User Training","excerpt":"Does anyone know if Smartsheet has ever had (or is planning) advanced user training available, similar to the Smartsheet Academy you can attend in person? or a User's Conference? It would be much easier to sit in a room with other advanced users and share ideas in person vs. on the web.","categoryID":318,"dateInserted":"2016-08-10T17:51:00+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-11T10:57:27+00:00","insertUserID":800,"insertUser":{"userID":800,"name":"Archie Lopez","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Archie%20Lopez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-02\/6e\/d9\/n6ed9a535713114243c20137ccc5a4f4c.JPG","dateLastActive":"2023-04-05T21:58:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":234,"lastUser":{"userID":234,"name":"Stephen Branstetter","url":"https:\/\/community.smartsheet.com\/profile\/Stephen%20Branstetter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/18\/9c\/n189cbca1a797d1528b418d7b428974d7.jpg","dateLastActive":"2021-05-10T15:51:58+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/5780\/advanced-user-training","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5780\/advanced-user-training","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"},{"tagID":444,"urlcode":"card-view","name":"Card View"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}],"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}]},{"discussionID":5761,"type":"discussion","name":"Links to external sites in a Report","excerpt":"I have a sheet with a column that includes a URL link to an external website. I have reports that include this column and I noticed that in the report the LINK is no longer a clickable link. I can double click on the cell and \"see\" and copy the URL but not click on it. Has anyone figured out a way to make the link an…","categoryID":318,"dateInserted":"2016-08-09T15:55:18+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-10T11:05:40+00:00","insertUserID":2137,"insertUser":{"userID":2137,"name":"Mike Otillio","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Otillio","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-28T10:03:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":2137,"lastUser":{"userID":2137,"name":"Mike Otillio","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Otillio","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-28T10:03:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":2,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/5761\/links-to-external-sites-in-a-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5761\/links-to-external-sites-in-a-report","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">