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

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

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

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-11T05:56:19.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":106300,"type":"idea","name":"EXTRACT function: select data between defined tags","excerpt":"Create an EXTRACT function to extract data between defined beginning and end tags. =EXTRACT(start string, end string, target cell\/range) USE CASE While there are many use cases for this function, I see it as a way to facilitate “lightweight” cross-sheet referencing. This function would allow you to package data from one…","categoryID":349,"dateInserted":"2023-06-10T03:57:52+00:00","dateUpdated":"2023-06-10T05:11:38+00:00","dateLastComment":"2023-06-11T02:08:13+00:00","insertUserID":129958,"insertUser":{"userID":129958,"name":"Lucas Rayala","title":"Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/Lucas%20Rayala","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3C9S_9DsC3w!XMDTX-y-BOY!7HVumwhOGBb","dateLastActive":"2023-06-11T02:09:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":129958,"lastUserID":129958,"lastUser":{"userID":129958,"name":"Lucas Rayala","title":"Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/Lucas%20Rayala","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3C9S_9DsC3w!XMDTX-y-BOY!7HVumwhOGBb","dateLastActive":"2023-06-11T02:09:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":42,"score":1,"hot":3372821465,"url":"https:\/\/community.smartsheet.com\/discussion\/106300\/extract-function-select-data-between-defined-tags","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106300\/extract-function-select-data-between-defined-tags","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106300,"commentID":379996,"name":"Re: EXTRACT function: select data between defined tags","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379996#Comment_379996","dateInserted":"2023-06-11T02:08:13+00:00","insertUserID":129958,"insertUser":{"userID":129958,"name":"Lucas Rayala","title":"Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/Lucas%20Rayala","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3C9S_9DsC3w!XMDTX-y-BOY!7HVumwhOGBb","dateLastActive":"2023-06-11T02:09:41+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":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106267,"type":"idea","name":"Have Smartsheet auto include a generated PDF in the notification email","excerpt":"Hello! Is there way to have Smartsheet auto include a generated PDF in the notification email it sends out once a form is filled out and submitted? I'm still relatively new to Smartsheet and I currently have the automation set up to generate a document with each form submission and send an email to a specified email…","categoryID":349,"dateInserted":"2023-06-09T14:04:36+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T16:14:01+00:00","insertUserID":155580,"insertUser":{"userID":155580,"name":"Emilie","url":"https:\/\/community.smartsheet.com\/profile\/Emilie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:07:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":155580,"lastUser":{"userID":155580,"name":"Emilie","url":"https:\/\/community.smartsheet.com\/profile\/Emilie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:07:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":20,"score":1,"hot":3372648217,"url":"https:\/\/community.smartsheet.com\/discussion\/106267\/have-smartsheet-auto-include-a-generated-pdf-in-the-notification-email","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106267\/have-smartsheet-auto-include-a-generated-pdf-in-the-notification-email","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106267,"commentID":379879,"name":"Re: Have Smartsheet auto include a generated PDF in the notification email","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379879#Comment_379879","dateInserted":"2023-06-09T16:14:01+00:00","insertUserID":155580,"insertUser":{"userID":155580,"name":"Emilie","url":"https:\/\/community.smartsheet.com\/profile\/Emilie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T16:07:55+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":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106207,"type":"idea","name":"Resize Image on Forms","excerpt":"Allow user to increase size of image on forms so that logos are more prominent and easier to read","categoryID":349,"dateInserted":"2023-06-08T15:24:27+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T19:39:23+00:00","insertUserID":162201,"insertUser":{"userID":162201,"name":"ritacoleHOPCo","title":"VP, IT Program Management","url":"https:\/\/community.smartsheet.com\/profile\/ritacoleHOPCo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T21:36:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":133951,"lastUser":{"userID":133951,"name":"Joe Goetschel","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Goetschel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QWNBAGYJ8LJG\/nJ2RMSJBMAY4K.jpg","dateLastActive":"2023-06-09T20:09:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":16,"score":2,"hot":3372578630,"url":"https:\/\/community.smartsheet.com\/discussion\/106207\/resize-image-on-forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106207\/resize-image-on-forms","format":"Rich","tagIDs":[204,363],"lastPost":{"discussionID":106207,"commentID":379923,"name":"Re: Resize Image on Forms","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379923#Comment_379923","dateInserted":"2023-06-09T19:39:23+00:00","insertUserID":133951,"insertUser":{"userID":133951,"name":"Joe Goetschel","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Goetschel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QWNBAGYJ8LJG\/nJ2RMSJBMAY4K.jpg","dateLastActive":"2023-06-09T20:09:24+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":204,"urlcode":"Forms","name":"Forms"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]}],"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">