在同一张工作表中链接
对于大型工作表，是否有一种方法可以从同一工作表中的行链接到其他行。例如，我开发了一个库，其中的文件属于不同的类别。有几个类别和大量的文件在每个类别。我在想我可以把每个类别都放在表格的顶部，并链接到它们在表格中的位置。任何帮助都是感激的。
评论
-
J.克雷格·威廉姆斯 ✭✭✭✭✭✭布莱尔,
您可以将值从一个单元格相等或拉到另一个单元格
= (columnname) 23
对于第23行和columnname列。
你可以在更复杂的公式中使用它
=IF([columnname]23="Bob"，"Will be late"，"Will be early")
这是关于函数的帮助文章
https://help.smartsheet.com/articles/775363-using-formulas
那里有很多有用的信息。
希望这对你有所帮助。
克雷格
-
我不太明白你的意思。
一个类别中的所有数据都分组在一起吗?也许是作为孩子，在表面上持有类别名称?
。在这种情况下，“全部折叠”操作(仅在主列的标题中可用)将提供一个汇总视图，可以帮助您快速切换到正确的类别。
。然而，你说你有很多类别，这个问题实际上可能是你的解决方案:为每个类别制作一个智能表。然后创建一个全新的智能表单，它实际上会成为你的转弯平台:它只会保存带有超链接到相关类别智能表单的类别名称。
。当您需要整合来自不同智能表的数据时，例如，收集来自所有类别的数据。使用报表引擎。容易使用，看https://help.smartsheet.com/articles/522214-creating-reports
-
我想我把别人弄糊涂了——或者我没有理解你的建议。下面是部分/桶的屏幕截图。每个部分下面都是一堆不同的文件，它们都链接到其他地方。由于它已经成为一个大的工作表，并继续增长，我想知道在工作表的顶部，我是否可以列出工作表上所有不同的类别，并链接到它们-都在同一个工作表内。下面是屏幕截图示例。
-
J.克雷格·威廉姆斯 ✭✭✭✭✭✭
链接到哪里?
我还是不明白。
克雷格
-
对不起-在表的顶部，我想有一行与每个部分的名称。所以把它想象成一个目录。在工作表的顶部是不同的部分，这些部分链接到工作表中该部分所在的位置。否则会有很多滚动。这就是链接——从工作表顶部的一行连接到工作表底部的一行。
-
J.克雷格·威廉姆斯 ✭✭✭✭✭✭
啊…不。
你有没有试过缩进部分下的项目，并折叠它们，直到需要它们?
不幸的是，没有键盘快捷键展开/折叠所有。
下面是另一个可能有助于缓解疼痛的功能:
Ctrl+Shift+F将弹出默认为当前工作表的搜索对话框。
使用你的目录，至少你知道要搜索什么。
Smartsheet注意事项:此快捷方式未在此处列出:
https://help.smartsheet.com/articles/522200-keyboard-shortcuts
克雷格
-
伟大的建议。谢谢。
类别
=IF([Weight (% of Completion]@row <> \"//www.santa-greenland.com/community/discussion/6665/\", [Weight (% of Completion]@row * [% Complete]@row)<\/p>
<\/p>
Then to add each piece together, you would use<\/p>
=SUM(CHILDREN([Helper Column]@row))<\/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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106318,"type":"question","name":"Look up multiple column values from Sheet B to match values in Sheet A to return value from Sheet B","excerpt":"Hello, I'm trying to make a formula that counts values from Sheet A against multiple columns in Sheet B, if only 1 total match is found, then lookup values from Sheet A against Sheet B and based on the result, pull in the value from a Status column. If either too many same results or no results are found return a text…","categoryID":322,"dateInserted":"2023-06-12T14:48:55+00:00","dateUpdated":null,"dateLastComment":"2023-06-13T11:45:16+00:00","insertUserID":158192,"insertUser":{"userID":158192,"name":"Clare123","url":"https:\/\/community.smartsheet.com\/profile\/Clare123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-13T12:26:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-14T10:47:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":62,"score":null,"hot":3373242851,"url":"https:\/\/community.smartsheet.com\/discussion\/106318\/look-up-multiple-column-values-from-sheet-b-to-match-values-in-sheet-a-to-return-value-from-sheet-b","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106318\/look-up-multiple-column-values-from-sheet-b-to-match-values-in-sheet-a-to-return-value-from-sheet-b","format":"Rich","lastPost":{"discussionID":106318,"commentID":380268,"name":"Re: Look up multiple column values from Sheet B to match values in Sheet A to return value from Sheet B","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380268#Comment_380268","dateInserted":"2023-06-13T11:45:16+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-14T10:47:26+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-13T10:56:36+00:00","dateAnswered":"2023-06-13T09:33:21+00:00","acceptedAnswers":[{"commentID":380250,"body":"
Hi @Clare123<\/a> <\/p> I hope you're well and safe!<\/p> Yes, absolutely.<\/p> Here's the structure.<\/p> =INDEX({ColumnWithTheValueYouWantToShow}, MATCH(CellThatHaveTheValueToMatch@row,{ColumnWithTheValueToMatchAgainsTheCell}, 0))<\/p> I hope that helps!<\/p> Be safe, and have a fantastic week!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":106314,"type":"question","name":"Flexible Duration value when calculating scheduling dates","excerpt":"I have a Smartsheet which is a project plan with the Dependencies and Duration columns is being used in scheduling calculations to automatically deriving the start\/end dates for each task. However, I need the Duration to be dynamic e.g. linking cell to a cell in another sheet or to contain a formulae.. However, I cannot…","categoryID":322,"dateInserted":"2023-06-12T12:39:46+00:00","dateUpdated":null,"dateLastComment":"2023-06-13T11:22:45+00:00","insertUserID":162290,"insertUser":{"userID":162290,"name":"Mark Duddy","title":"Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Duddy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-13T11:41:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-14T12:06:55+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":60,"score":null,"hot":3373230151,"url":"https:\/\/community.smartsheet.com\/discussion\/106314\/flexible-duration-value-when-calculating-scheduling-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106314\/flexible-duration-value-when-calculating-scheduling-dates","format":"Rich","lastPost":{"discussionID":106314,"commentID":380264,"name":"Re: Flexible Duration value when calculating scheduling dates","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380264#Comment_380264","dateInserted":"2023-06-13T11:22:45+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-14T12:06:55+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-13T11:24:19+00:00","dateAnswered":"2023-06-13T11:22:45+00:00","acceptedAnswers":[{"commentID":380264,"body":"
