登录提交新的想法和投票
开始

需要解决主列的智能表问题

报表必须使用工作表的主列,且主列必须位于报表的第一列中。报告组的标签显示在报告的主列中,因此,如果您不想查看报告中的主列,或者隐藏主列,则组的标签将被隐藏。如果您将行复制到另一个工作表,并可能将复制工作表中的主列更改为您希望在报告中查看的列,那么您还需要确保工作表的数据同步。您将需要管理相同数据的至少两个副本。

13
13票

想法提交·最后一次更新

评论

  • 我从IT请求管理解决方案中心下载了一组模板。第三栏“Issue Description”为主栏。第一列“Issue Key”是列类型“# Auto number”。

    我怎样才能做到呢?我想我必须总是把主列作为第一列吗?

  • 李Joramo
    李Joramo ✭✭✭✭✭

    您可以拖放列以重新排序它们。主列也不例外。

  • You can drag and drop columns to reorder them. The Primary Column is no different.<\/p>","bodyRaw":"[{\"insert\":\"You can drag and drop columns to reorder them. The Primary Column is no different. \\n\"}]","format":"rich","dateInserted":"2022-09-23T17:49:45+00:00","insertUser":{"userID":52131,"name":"Lee Joramo","url":"https:\/\/community.smartsheet.com\/profile\/Lee%20Joramo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-03\/84\/d4\/n84d4d5e3d909b0164c8e3ad8f8e5c934.jpg","dateLastActive":"2023-05-17T20:20:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344604#Comment_344604","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/344604#Comment_344604

    只有当你不分组报表-如果你使用分组主列不会移动。

    • 当分组或摘要处于活动状态时,可以将列移动到报表中主列的左侧。
    • 甘特时间轴中文本标签的字体颜色将自动设置为与网格中行中使用的字体颜色相同的字体颜色,或者手动更改文本标签的字体颜色的能力。
    • 将层次结构扩展到特定级别而不是扩展所有级别的能力。


  • 在报告具有不同主列的工作表时,能够在隐藏主列的同时仍然显示分组将非常有用。有时不可能重新排列工作表,使其具有相同的主列,特别是如果一个是项目计划,必须是任务名称,而另一个工作表不是。

  • 将Grouping Label绑定到主列是限制性的。我有一个大的工作表,此时无法对其进行重新配置,并且我不希望在仍然希望进行分组的特定报表上显示主列。希望他能尽快修好。谢谢!

2023-05-24T03:01:10.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":106828,"type":"idea","name":"Increase cell character count","excerpt":"I use Smartsheet to document contract compliance. Sometimes compliance actions can take up to 2 years and I exceed the 4,000 characters in an excel cell. Is there a way to increase the # of characters in a cell?","categoryID":349,"dateInserted":"2023-06-23T14:26:58+00:00","dateUpdated":"2023-06-23T14:29:01+00:00","dateLastComment":"2023-06-23T14:39:15+00:00","insertUserID":162424,"insertUser":{"userID":162424,"name":"Kirsten George","title":"Compliance Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Kirsten%20George","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BJtogbPi6ns!nR9q38OJjvM!iSUyXXTv3O_","dateLastActive":"2023-06-23T14:40:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"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":"2023-06-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":19,"score":2,"hot":3375062773,"url":"https:\/\/community.smartsheet.com\/discussion\/106828\/increase-cell-character-count","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106828\/increase-cell-character-count","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106828,"commentID":381984,"name":"Re: Increase cell character count","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381984#Comment_381984","dateInserted":"2023-06-23T14:39:15+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":"2023-06-23T19:11:32+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"}]},{"discussionID":106820,"type":"idea","name":"Stacked column for two dimensional view, combining 2 groups in one column","excerpt":"We would like to be able to see in one stacked column\/bar the combination of two data groupings... ex first category group (=name column) with as subgroup phase mentioning for the items in this category (stacked items in the column by category). Currently not possible to see this in the chart widgets. Solution offered is…","categoryID":349,"dateInserted":"2023-06-23T12:35:05+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T14:40:59+00:00","insertUserID":105276,"insertUser":{"userID":105276,"name":"Ilse Ickx","url":"https:\/\/community.smartsheet.com\/profile\/Ilse%20Ickx","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-09\/25\/36\/n2536b42cfc3ef8ddda62c4bbbfb06667.jpg","dateLastActive":"2023-06-23T12:35:08+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":"2023-06-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":2,"hot":3375056764,"url":"https:\/\/community.smartsheet.com\/discussion\/106820\/stacked-column-for-two-dimensional-view-combining-2-groups-in-one-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106820\/stacked-column-for-two-dimensional-view-combining-2-groups-in-one-column","format":"Rich","tagIDs":[292,363],"lastPost":{"discussionID":106820,"commentID":381985,"name":"Re: Stacked column for two dimensional view, combining 2 groups in one column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381985#Comment_381985","dateInserted":"2023-06-23T14:40:59+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":"2023-06-23T19:11:32+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":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"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-23T05:49:08+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":46,"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"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-05-24T03%3A01%3A10%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":141,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">