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

重命名报告中的列名

1)是否可以更改报告中的列名而不是源表。

2)自动列名出现在报表中,而不是列名(例如:创建日期、修改日期、创建日期和修改日期)。是否有任何方法可以更改报表中的“系统列”名称。

谢谢你的支持。

致以最亲切的问候。

标签:
5
5票

想法提交·最后一次更新

评论

  • DW1
    DW1 ✭✭✭✭

    要求报表在列名更改时自动更新。目前,重命名工作表中的列将破坏引用该工作表列的任何报表。报告应该引用后端列ID,而不是UI中的列别名。

  • 谢谢你的评论。

    我的场景是不同的,我在报告中寻找计算列,而不是在源文件中创建新列。我有7个级别的审批,我想知道审批周期,在这种情况下,我在源文件中创建了7个新列,而不是在报告中创建计算列,这将有助于我们避免每次在源文件中创建新列。

    我希望它将有利于用户创建多个报告。

    谢谢你的支持。

    致以最亲切的问候。

2023-05-11T05:38:36.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":[]}">