使用工作表摘要数据字段的图表仪表板小部件
这将是伟大的，能够使用图表小部件的数据保存在表摘要级别。
有两种方法可以解决这个问题:
- 据此创建一个报告和图表
- 向工作表本身添加“辅助列”
但是，我希望减少创建的新报表的数量，并在不添加新列的情况下降低表的复杂性。我们不能直接根据表格汇总数据来做图表吗?
评论
-
安东尼•里斯 ✭✭
为此，我养成了创建“总结表”的习惯。我发现有时我需要以一种特定的方式来排列数据，这会使主表混乱。话虽如此，我还是欢迎从工作表摘要中提取数据以简化解决方案的功能。谢谢你的建议。
类别
2023-05-22T20:30:21.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":106750,"type":"idea","name":"Portfolio Management: Team member part-time availability on Projects","excerpt":"I need the ability to set part-time availability for a team member to specific projects, i.e. working Mon-Wed on Project A and Thu-Fri on Project B. For each project and each team member you could set working days, that would solve this problem. I have a team member in high demand, between two projects an agreement was…","categoryID":349,"dateInserted":"2023-06-22T02:36:38+00:00","dateUpdated":"2023-06-22T04:15:08+00:00","dateLastComment":"2023-06-22T08:22:54+00:00","insertUserID":154130,"insertUser":{"userID":154130,"name":"rshiers","url":"https:\/\/community.smartsheet.com\/profile\/rshiers","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pDnTaRzNqD0!w28qv0IRvXo!4Gl7IBwphF9","dateLastActive":"2023-06-22T07:53:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":154130,"lastUserID":162621,"lastUser":{"userID":162621,"name":"Gmosedale","title":"Senior Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Gmosedale","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nUDo_9-vCQo!e5kox3O7Izo!Q_5KCuITavv","dateLastActive":"2023-06-22T13:18:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":34,"score":1,"hot":3374825072,"url":"https:\/\/community.smartsheet.com\/discussion\/106750\/portfolio-management-team-member-part-time-availability-on-projects","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106750\/portfolio-management-team-member-part-time-availability-on-projects","format":"Rich","tagIDs":[319,363,440,468,505,507],"lastPost":{"discussionID":106750,"commentID":381681,"name":"Re: Portfolio Management: Team member part-time availability on Projects","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381681#Comment_381681","dateInserted":"2023-06-22T08:22:54+00:00","insertUserID":162621,"insertUser":{"userID":162621,"name":"Gmosedale","title":"Senior Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Gmosedale","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nUDo_9-vCQo!e5kox3O7Izo!Q_5KCuITavv","dateLastActive":"2023-06-22T13:18:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":468,"urlcode":"resource-management","name":"Resource Management"},{"tagID":505,"urlcode":"scheduling","name":"Scheduling"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"}]},{"discussionID":106681,"type":"idea","name":"An instant shout-out to improvements","excerpt":"I wish there is an easy way to send an instant shout-out to the team that makes Smartsheet better, something like a hyperlink that delivers feedback to the correct team. Most of the time teams that work behind the scenes receive criticism, it is equally important for them to know what they did is greatly appreciated. Thank…","categoryID":349,"dateInserted":"2023-06-21T05:34:53+00:00","dateUpdated":null,"dateLastComment":"2023-06-21T11:59:43+00:00","insertUserID":150280,"insertUser":{"userID":150280,"name":"MMcLain","url":"https:\/\/community.smartsheet.com\/profile\/MMcLain","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!u7Ha993vpH4!XXja323iCiY!CVqD2qrygnO","dateLastActive":"2023-06-21T05:34:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"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-06-22T19:48:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":14,"score":1,"hot":3374675376,"url":"https:\/\/community.smartsheet.com\/discussion\/106681\/an-instant-shout-out-to-improvements","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106681\/an-instant-shout-out-to-improvements","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106681,"commentID":381445,"name":"Re: An instant shout-out to improvements","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381445#Comment_381445","dateInserted":"2023-06-21T11:59:43+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-06-22T19:48:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106445,"type":"idea","name":"Status field in RM should be synced to Smartsheet and vice-versa","excerpt":"Some conventions and mapping should be put in place to make it possible for those who want this functionality.","categoryID":349,"dateInserted":"2023-06-14T17:51:13+00:00","dateUpdated":"2023-06-14T17:51:44+00:00","dateLastComment":"2023-06-22T02:26:30+00:00","insertUserID":150692,"insertUser":{"userID":150692,"name":"Ronny Dorian","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ronny%20Dorian","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n65S9PRP4PA0M.png","dateLastActive":"2023-06-22T02:25:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":154130,"lastUser":{"userID":154130,"name":"rshiers","url":"https:\/\/community.smartsheet.com\/profile\/rshiers","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pDnTaRzNqD0!w28qv0IRvXo!4Gl7IBwphF9","dateLastActive":"2023-06-22T07:53:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":27,"score":2,"hot":3374167063,"url":"https:\/\/community.smartsheet.com\/discussion\/106445\/status-field-in-rm-should-be-synced-to-smartsheet-and-vice-versa","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106445\/status-field-in-rm-should-be-synced-to-smartsheet-and-vice-versa","format":"Rich","tagIDs":[363,468],"lastPost":{"discussionID":106445,"commentID":381656,"name":"Re: Status field in RM should be synced to Smartsheet and vice-versa","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381656#Comment_381656","dateInserted":"2023-06-22T02:26:30+00:00","insertUserID":154130,"insertUser":{"userID":154130,"name":"rshiers","url":"https:\/\/community.smartsheet.com\/profile\/rshiers","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pDnTaRzNqD0!w28qv0IRvXo!4Gl7IBwphF9","dateLastActive":"2023-06-22T07:53:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":468,"urlcode":"resource-management","name":"Resource Management"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-05-22T20%3A30%3A21%2B00%3A00&type%5B0%5D=Idea&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":144,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
