取消链接-多行
我需要连接50个细胞库存在我的牢房里库存的价格床单我可以作为一个小组来做吗?我尝试选择库存表中的所有单元格，然后选择链接选项，导航到库存价格表并选择我需要链接到所有50个单元格的单元格。使用这个过程，它只在我的范围内填充第一个单元格。
任何想法吗?
评论
-
L_123 ✭✭✭✭✭✭单元格链接不能这样做。相反，您需要使用列引用并返回索引的范围。
=index({Column Reference from other sheet}，1)
将返回列中的第一个值。您可以在每个单元格中手动输入1 - 50以引用每个返回值，或者如果您从页面顶部开始，您可以这样做
=index({Column Reference from other sheet}，1+count([Current Column]$1:[CurrentColumn]1))
然后在第二个单元格中向下拖动。
-
保罗新来的 ✭✭✭✭✭✭只要两个分组具有相同的大小(和形状)，就可以同时链接多个单元格。为例。如果要将一行中的50个单元格进行单元格链接，则需要选择这50个单元格，从其他单元格链接，然后选择其他50个单元格。他们必须是50个单元格下一行的工作，虽然。如果要链接一个3 × 4的网格，请突出显示该区域，从其他单元格链接，然后在另一个工作表上选择一个3 × 4的网格。如果行数和列数不匹配，它将无法工作。
听起来像…您希望将来自50个单元格的数据合并为1个单元格，在这种情况下，您将使用JOIN函数并引用另一个工作表。
thinkspi.com
-
嗨,保罗,
我很抱歉这么晚才回复你。谢谢你的意见。我总是喜欢学习新的函数。我通常有非常基本的表格，但被迫进入下一个SmartSheet级别!
-
希望C。 ✭
在我的例子中，我有联系人表(包括联系方式)，和仅包含联系人姓名的项目列表表。我希望能够将项目表上的联系人姓名链接到联系人表上的联系人姓名，这样我就没有列出他们所关联的每个项目上的联系人详细信息。这个联系人不是贡献者，也没有SS帐户，所以我不想将它们“分配”给单元格。通过链接这两张表格，它减少了每次在项目中出现联系人名字时列出联系人信息的重复。他们的联系信息保持准确，因为它只在联系人表上列出一次。我今天遇到了一个问题，我不能在我的项目表上多选择单元格，并链接到联系人列表表上的同一联系人。我应该考虑其他解决方案吗?
类别
You are welcome. One Day the platform will allow this but for now we wait. If my answer was sufficient please mark your question as answered.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":105945,"type":"question","name":"Dashboard reports not showing on published dashboard in SharePoint","excerpt":"I have embedded a Smartsheet dashboard in a SharePoint Online site. Some reports show just fine, two do not and I can't figure out why. I published the dashboard and grabbed the embed code. Used an embed web part in SharePoint to embed the dashboard. Two reports show fine, the other two have errors. There is nothing…","categoryID":321,"dateInserted":"2023-06-02T12:17:45+00:00","dateUpdated":null,"dateLastComment":"2023-06-02T12:33:24+00:00","insertUserID":81546,"insertUser":{"userID":81546,"name":"Andrea Zenner","url":"https:\/\/community.smartsheet.com\/profile\/Andrea%20Zenner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-03\/c8\/bb\/nc8bb6b7bd2a9297545e5baeb6a5ba8ed.jpg","dateLastActive":"2023-06-02T12:33:56+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-02T20:54:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":36,"score":null,"hot":3371419869,"url":"https:\/\/community.smartsheet.com\/discussion\/105945\/dashboard-reports-not-showing-on-published-dashboard-in-sharepoint","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105945\/dashboard-reports-not-showing-on-published-dashboard-in-sharepoint","format":"Rich","tagIDs":[265,292],"lastPost":{"discussionID":105945,"commentID":378523,"name":"Re: Dashboard reports not showing on published dashboard in SharePoint","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378523#Comment_378523","dateInserted":"2023-06-02T12:33:24+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-02T20:54: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\/PF6NIRYD5DHX\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-02T12:34:10+00:00","dateAnswered":"2023-06-02T12:33:24+00:00","acceptedAnswers":[{"commentID":378523,"body":"
That is exactly it. Is the \"Their Own Perspective\" the broken one? Basically... You have to be logged in to Smartsheet for Smartsheet to know who is viewing the report so that it can provide the correct \"perspective\".<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":265,"urlcode":"Reports","name":"Reports"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
