表格上的列描述没有显示在报告上

佩吉
佩吉 ✭✭✭✭✭
在内容基本知识

你好,

我有两页列描述。我已经通过报告共享了这些表，供用户进行更新。从报告中，他们看不到列描述。

有没有办法让他们看到列的描述?

谢谢,

佩吉

· 在Facebook上分享 在推特上分享

答案

类别

@Peggy<\/a> <\/p>

You're right about adding the Product Lines to the 2nd sheet with the department\/users. After you do that, on the 1st sheet you'll want to use an INDEX\/MATCH formula which drags in the user who needs the notification. You'll match against the product line listed on sheet 1 and 2.<\/p>

Once you've got that setup and working, on the 1st sheet you can create an automation which is triggered by the date field and alerts the contact field which is the user who's INDEX\/MATCHed from the 2nd sheet.<\/p>"},{"commentID":357032,"body":"

@Peggy<\/a> <\/p>

You may need to use an INDEX\/COLLECT formula instead if you have multiple people listed on the 2nd sheet and you want to pull in someone with a specific title. COLLECT will help you specify multiple criteria which would be the product line criteria and the person's title criteria.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-12 23:19:42","updateUser":{"userID":35911,"name":"Peggy","url":"https:\/\/community.smartsheet.com\/profile\/Peggy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7Htee2AaTfQ!htPdobx0PT4!J2mAMiaMDmW","dateLastActive":"2023-01-12T23:19:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":99612,"type":"question","name":"Issues with cells in a spreadsheet on computer assets","excerpt":"It appears that a large number of cells in the spreadsheet, in a column for costs, have changed from dollar amounts to dates. The column type is set to Text\/Number. Any idea on why this might happen, all cells have the change dat as 8\/10\/22. Thanks in advance, Joe Busch jbusch@urban.org","categoryID":321,"dateInserted":"2023-01-12T15:58:33+00:00","dateUpdated":null,"dateLastComment":"2023-01-12T20:42:49+00:00","insertUserID":11262,"insertUser":{"userID":11262,"name":"Joe Busch","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Busch","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-12T20:42:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11262,"lastUser":{"userID":11262,"name":"Joe Busch","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Busch","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-12T20:42:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":32,"score":null,"hot":3347097682,"url":"https:\/\/community.smartsheet.com\/discussion\/99612\/issues-with-cells-in-a-spreadsheet-on-computer-assets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99612\/issues-with-cells-in-a-spreadsheet-on-computer-assets","format":"Rich","lastPost":{"discussionID":99612,"commentID":356984,"name":"Re: Issues with cells in a spreadsheet on computer assets","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/356984#Comment_356984","dateInserted":"2023-01-12T20:42:49+00:00","insertUserID":11262,"insertUser":{"userID":11262,"name":"Joe Busch","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Busch","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-12T20:42:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-12T18:56:53+00:00","dateAnswered":"2023-01-12T17:57:14+00:00","acceptedAnswers":[{"commentID":356943,"body":"

Have you looked at the activity log and\/or cell history?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-12 18:56:53","updateUser":{"userID":11262,"name":"Joe Busch","url":"https:\/\/community.smartsheet.com\/profile\/Joe%20Busch","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-12T20:42:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":99580,"type":"question","name":"Rename Folders Provisioned by Control Center","excerpt":"Hello All I have provisioned about 100 project toolkits through Control Center, and I don't like the way the folders in Smartsheet are sorting. Can I rename the folders in Smartsheet without breaking anything with future global updates? I would like to rename the folder for all the projects provisioned to have the unique…","categoryID":343,"dateInserted":"2023-01-11T22:01:41+00:00","dateUpdated":"2023-01-11T22:02:46+00:00","dateLastComment":"2023-01-13T12:05:01+00:00","insertUserID":11482,"insertUser":{"userID":11482,"name":"Lori Khoury","url":"https:\/\/community.smartsheet.com\/profile\/Lori%20Khoury","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-13T12:04:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":11482,"lastUserID":11482,"lastUser":{"userID":11482,"name":"Lori Khoury","url":"https:\/\/community.smartsheet.com\/profile\/Lori%20Khoury","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-13T12:04:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3347087202,"url":"https:\/\/community.smartsheet.com\/discussion\/99580\/rename-folders-provisioned-by-control-center","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99580\/rename-folders-provisioned-by-control-center","format":"Rich","tagIDs":[466],"lastPost":{"discussionID":99580,"commentID":357050,"name":"Re: Rename Folders Provisioned by Control Center","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/357050#Comment_357050","dateInserted":"2023-01-13T12:05:01+00:00","insertUserID":11482,"insertUser":{"userID":11482,"name":"Lori Khoury","url":"https:\/\/community.smartsheet.com\/profile\/Lori%20Khoury","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-13T12:04:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/DURYQ6J3VSBL\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-13T12:04:29+00:00","dateAnswered":"2023-01-12T14:04:10+00:00","acceptedAnswers":[{"commentID":356864,"body":"

You should be ok to rename folders, but it would be a rather manual process. Last time I looked at Global Updates, they didn't have something to do folder names.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-13 12:04:29","updateUser":{"userID":11482,"name":"Lori Khoury","url":"https:\/\/community.smartsheet.com\/profile\/Lori%20Khoury","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-13T12:04:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":466,"urlcode":"control-center","name":"Control Center"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">