如何按行更改仪表板的指标
你好,
我有一张表，上面有潜在项目的信息。每个项目都有一个包含信息的主行，我已经链接到一个仪表板。这个想法是，我将pdf与项目信息的仪表板，很像一个提案。我想使它，所以我只有一个仪表板，我可以改变行，它引用，而不是有每个项目的仪表板。
-我试过通过报告过滤，但仪表板主要使用指标小部件，所以不能与报告一起工作。
-我试过在工作表的顶部有一行，将通过在另一个单元格中输入行号来镜像所需的行。我认为这可能在Excel中作为Concatenate工作，但Smartsheet中的单元格引用的工作方式不同。
欢迎提出任何建议!
谢谢,
卡拉
最佳答案
-
吉纳维芙P。 员工管理目前还没有一种方法可以在仪表板上应用动态过滤器，以便自定义从工作表中显示的数据。
你的解决方案有一行在一个工作表，将带来你想要的数据(然后使用那一行作为你在仪表板中引用的行)是我的建议!
你可以用INDEX函数搜索您的列并返回某一行:
=INDEX([列名]:[列名]，rownumber）
这里我要做的是在最上面的行有一个单元格你可以输入你想要取回的行号。然后您可以在公式中引用此单元格，如下所示:
=INDEX([Primary Column]:[Primary Column]，$[Row to Bring Back]@row)
让我知道如果这是有意义的，将为您工作!
欢呼,
吉纳维芙
答案
-
吉纳维芙P。 员工管理
目前还没有一种方法可以在仪表板上应用动态过滤器，以便自定义从工作表中显示的数据。
你的解决方案有一行在一个工作表，将带来你想要的数据(然后使用那一行作为你在仪表板中引用的行)是我的建议!
你可以用INDEX函数搜索您的列并返回某一行:
=INDEX([列名]:[列名]，rownumber）
这里我要做的是在最上面的行有一个单元格你可以输入你想要取回的行号。然后您可以在公式中引用此单元格，如下所示:
=INDEX([Primary Column]:[Primary Column]，$[Row to Bring Back]@row)
让我知道如果这是有意义的，将为您工作!
欢呼,
吉纳维芙
-
卡拉B ✭太棒了!谢谢你，吉纳维芙，
这个建议真的很有用。现在很高兴知道我可以按行返回信息。
如果这对其他人有帮助，我将上面的内容改编为Index/Match，并为相关行(不是所有行都需要返回)添加ID列，这样，如果行号改变，引用行的数据不会改变。
再次感谢,
卡拉
帮助文章参考资料欧宝体育app官方888
类别
=IF(FIND(\"Local\"; Campaign@row)> 0; \"Local\"; IF(FIND(\"Relocation\"; Campaign@row)> 0; \"Relocation\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":106115,"type":"question","name":"Nested IF formula with input from 2 different columns possible?","excerpt":"I am stuck on a nested if formula. I have 2 columns that set 1 of 3 statuses in a 4th column, here is the basic break down if \"APPR'VD BY ARCH'T\" is blank, display Awarded in \"Project Ordering Status\" column, if \"APPR'VD BY ARCH'T\" is a date, display ABA in \"Project Ordering Status\" column. Here is the formula that I have…","categoryID":322,"dateInserted":"2023-06-07T02:16:15+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T12:47:14+00:00","insertUserID":152512,"insertUser":{"userID":152512,"name":"Pnda","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pnda","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/VEPTPHP1NOUN\/nRTHYGU10N8SJ.jpeg","dateLastActive":"2023-06-07T12:47:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":152512,"lastUser":{"userID":152512,"name":"Pnda","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pnda","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/VEPTPHP1NOUN\/nRTHYGU10N8SJ.jpeg","dateLastActive":"2023-06-07T12:47:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":19,"score":null,"hot":3372247409,"url":"https:\/\/community.smartsheet.com\/discussion\/106115\/nested-if-formula-with-input-from-2-different-columns-possible","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106115\/nested-if-formula-with-input-from-2-different-columns-possible","format":"Rich","lastPost":{"discussionID":106115,"commentID":379248,"name":"Re: Nested IF formula with input from 2 different columns possible?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379248#Comment_379248","dateInserted":"2023-06-07T12:47:14+00:00","insertUserID":152512,"insertUser":{"userID":152512,"name":"Pnda","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pnda","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/VEPTPHP1NOUN\/nRTHYGU10N8SJ.jpeg","dateLastActive":"2023-06-07T12:47:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/SDE46MQW3XRN\/screenshot-2023-06-06-at-10-14-38-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-06-06 at 10.14.38 PM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-07T12:47:31+00:00","dateAnswered":"2023-06-07T03:39:49+00:00","acceptedAnswers":[{"commentID":379197,"body":"
I am having some difficulty following exactly what you want. This is what I think you mean, but please correct me if I am wrong.<\/p>
IF(ISDATE([FAB RLS DATE]@row), \"RFF\", IF([APPR'VD BY ARCH'T]@row = \"\", \"Awarded\", IF(ISDATE([APPR'VD BY ARCH'T]@row), \"ABA\")))<\/p>
<\/p>
This will set [PROJECT ORDERING STATUS] equal to the following values, with this order of priority:<\/p>
- \"RFF\" if there is a date in the [FAB RLS DATE] column, regardless of the contents of [APPR'VD BY ARCH'T].<\/li>
- \"Awarded\" if [APPR'VD BY ARCH'T] is blank and [FAB RLS DATE] does not contain a date.<\/li>
- \"ABA\" if [APPR'VD BY ARCH'T] contains a date and [FAB RLS DATE] does not contain a date.<\/li><\/ol>
<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":106091,"type":"question","name":"How to reference column name pulled from formula","excerpt":"I'm trying to pull a date from columns based on the number in the helper column. I know I can do this with nested IFs, but is there a way to change which column I'm pulling the value from? My column Start Date should be whatever the column is based on the Index. So for the first column below, since Index is 3, it should…","categoryID":322,"dateInserted":"2023-06-06T19:01:04+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T12:03:41+00:00","insertUserID":162114,"insertUser":{"userID":162114,"name":"mwat4482","url":"https:\/\/community.smartsheet.com\/profile\/mwat4482","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-07T12:34:48+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-07T12:32:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":43,"score":null,"hot":3372219285,"url":"https:\/\/community.smartsheet.com\/discussion\/106091\/how-to-reference-column-name-pulled-from-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106091\/how-to-reference-column-name-pulled-from-formula","format":"Rich","lastPost":{"discussionID":106091,"commentID":379221,"name":"Re: How to reference column name pulled from formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379221#Comment_379221","dateInserted":"2023-06-07T12:03:41+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-07T12:32:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/EITIHXA4Y0I7\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-06T19:24:45+00:00","dateAnswered":"2023-06-06T19:18:07+00:00","acceptedAnswers":[{"commentID":379128,"body":"Are you trying to use that as a dynamic cell reference? If so, that is not possible. What it looks to me like you need is something more along the lines of<\/p>
=INDEX([1st Date Column]@row:[Last Date Column]@row, 1, Index@row)<\/p>
<\/p>You are going to need to update the column names in the formula to match what you are using in your sheet.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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 Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
