智能表报告单元连接不工作

你好,

我试图编辑一个智能表报告来更新仪表板,但无法获得内容来填充。我将正确的单元格链接到一个名为Portfolio的汇总表中,数据正在正确地填充。但是,当我将一个特定的列数据从Portfolio拉入名为report的报表表时,该列确实出现了,但内容没有出现。这表明它连接到正确的细胞。我还尝试删除和重新添加过滤器,看看这是否是原因,它仍然不会填充单元格中的数据,即使它是链接正确的。我还尝试创建一个新的报告,当我添加到该列时,它仍然不包含数据。该报告与Portfolio Dashboard绑定,我需要显示特定的列单元格内容。现在,只显示列标题,但单元格为空。

任何帮助将不胜感激!


最好的问候,

P贝克

答案

  • 保罗新来的
    保罗新来的 ✭✭✭✭✭✭

    是否有可能将报告链接到一个名称相同(或相似)的表,但恰巧是空白的?

    thinkspi.com

Because the data in the hierarchy column is different. There are no ancestors that have a \"1\", so there is nothing to pull.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-03 20:51:53","updateUser":{"userID":144713,"name":"Dakota Haeffner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Dakota%20Haeffner","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-9EoN6cCJXs!7Dcqe8-aSLs!vmL02Fkj5JV","dateLastActive":"2022-08-03T21:43:52+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":93872,"type":"question","name":"update request link expiration","excerpt":"Hello All, Do you know how long a link is open if no changes are made to it? I think it used to be 30 days but am not sure if that is true now. Thank you!","categoryID":321,"dateInserted":"2022-08-03T13:14:02+00:00","dateUpdated":null,"dateLastComment":"2022-08-03T17:28:52+00:00","insertUserID":88916,"insertUser":{"userID":88916,"name":"Melanie Sanders","url":"https:\/\/community.smartsheet.com\/profile\/Melanie%20Sanders","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!j_dP49SAvro!m2jOf2yrXaY!PxpOPNHIXga","dateLastActive":"2022-08-03T20:20:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":150223,"lastUser":{"userID":150223,"name":"Heather_Verde","url":"https:\/\/community.smartsheet.com\/profile\/Heather_Verde","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-03T20:42:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":14,"score":null,"hot":3319081374,"url":"https:\/\/community.smartsheet.com\/discussion\/93872\/update-request-link-expiration","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93872\/update-request-link-expiration","format":"Rich","tagIDs":[446],"lastPost":{"discussionID":93872,"commentID":338502,"name":"Re: update request link expiration","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/338502#Comment_338502","dateInserted":"2022-08-03T17:28:52+00:00","insertUserID":150223,"insertUser":{"userID":150223,"name":"Heather_Verde","url":"https:\/\/community.smartsheet.com\/profile\/Heather_Verde","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-03T20:42:49+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":"2022-08-03T20:20:16+00:00","dateAnswered":"2022-08-03T17:28:52+00:00","acceptedAnswers":[{"commentID":338502,"body":"

I have an update request in my queue that I am able to access from June. So that is longer than 30 days.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-03 20:20:16","updateUser":{"userID":88916,"name":"Melanie Sanders","url":"https:\/\/community.smartsheet.com\/profile\/Melanie%20Sanders","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!j_dP49SAvro!m2jOf2yrXaY!PxpOPNHIXga","dateLastActive":"2022-08-03T20:20:05+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":[{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}]},{"discussionID":93850,"type":"question","name":"How do I structure my data to show a fixed and autonomous double line graph?","excerpt":"Hi Smartsheet Community, I am looking to create a double line graph to help show if someone is on track or falling behind. This is my idea: The red line is fixed and is decided based upon the start and targeted finish date. The black line is data that is pulled each week via workflow and put onto a report. I am wanting to…","categoryID":321,"dateInserted":"2022-08-02T19:19:33+00:00","dateUpdated":null,"dateLastComment":"2022-08-03T19:04:50+00:00","insertUserID":150014,"insertUser":{"userID":150014,"name":"masonebe","url":"https:\/\/community.smartsheet.com\/profile\/masonebe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-03T20:16:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":150014,"lastUser":{"userID":150014,"name":"masonebe","url":"https:\/\/community.smartsheet.com\/profile\/masonebe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-03T20:16:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":20,"score":null,"hot":3319025663,"url":"https:\/\/community.smartsheet.com\/discussion\/93850\/how-do-i-structure-my-data-to-show-a-fixed-and-autonomous-double-line-graph","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93850\/how-do-i-structure-my-data-to-show-a-fixed-and-autonomous-double-line-graph","format":"Rich","lastPost":{"discussionID":93850,"commentID":338555,"name":"Re: How do I structure my data to show a fixed and autonomous double line graph?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/338555#Comment_338555","dateInserted":"2022-08-03T19:04:50+00:00","insertUserID":150014,"insertUser":{"userID":150014,"name":"masonebe","url":"https:\/\/community.smartsheet.com\/profile\/masonebe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-03T20:16:24+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/J2V240C7ZCAZ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-03T18:27:38+00:00","dateAnswered":"2022-08-03T17:38:51+00:00","acceptedAnswers":[{"commentID":338504,"body":"

View below<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-03 18:27:38","updateUser":{"userID":150014,"name":"masonebe","url":"https:\/\/community.smartsheet.com\/profile\/masonebe","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-03T20:16:24+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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">