将数据表中的几列连接到另一个表
答案
-
乔恩马克H ✭✭✭✭
嗨,克里斯!
你能详细说说你想做什么吗:
1)。你是在新的/更薄的表格中使用大数据表中的每一行，还是只使用特定的行?
2)。床单之间是否有某种共享的、独特的参考?(例如零件编号、零件名称、活动?)
如果你正在使用所有的行，或者你没有一个唯一的引用已经在两个工作表-你可以链接整个列
方法如下:
步骤1)。创建一个你想要链接的列(在我的例子中我将我的命名为“Linked column”)
步骤2)。右键单击你想要数据所在列的TOP单元格，然后选择“链接到其他工作表中的单元格”
步骤3)。选择要链接的列的COLUMN HEADER。(此处选择“任务名称”)
步骤4)。点击“创建链接”——这将把该列中的所有数据从另一个工作表拉到你的新精简工作表中。您可以对多个列重复此操作。
让我知道这是否满足你的需求，或者如果你只有特定的行你想拉过来/有一个唯一的标识符在两个表-在这种情况下，你会想要使用索引/匹配。
如果你还需要任何其他帮助，请告诉我!
乔恩马克
1 -
她名叫Stara ✭✭✭✭✭✭我希望你平安无事!
我建议将索引/MATCH与自动编号列结合起来。
是这样的。
=指数({ColumnWithTheValueYouWantToShow};匹配((电子邮件保护)；{ColumnWithTheValueToMatchAgainsTheCell};0))根据您的国家/地区，您需要将逗号替换为句号，将分号替换为逗号。
有意义吗?
工作/帮助吗?
我希望这对你有帮助!
注意安全，祝你周末愉快!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区通过将其标记为有洞察力/投票支持或/和作为公认的答案．这将使别人更容易找到解决方案或帮助回答!
Smartsheet合伙人&顾问/专家
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
如果您需要Smartsheet、集成、一般工作流建议或其他方面的帮助，请随时与我联系。
0 -
Chood ✭在我的主表单中，我有很多列，里面有很多与我正在尝试做的事情无关的信息。
我正试图引入仅仅几列的清洁页上执行计算和自动化。
例如，我想把技术人员姓名、协调员姓名、执行的活动和执行的产品活动带到新表中。ob欧宝娱乐app手机下载
进入新表格后，我希望填充一个预期收入列，该列将由自动化根据活动和产品确定。ob欧宝娱乐app手机下载我可以这样做，但是我很难掌握函数实时复制数据到收入表的语法概念。
上面的第一个建议很有效，但它似乎只适用于表格中已经存在的内容。当新行添加到doner工作表时，它不会被带到第二个工作表。
我试着理解第二条建议的句法。我差点就明白了，但还是很挣扎。
下面是我的屏幕截图。如果我能得到适用于我的情况的语法，我的灯泡可能会亮起来，我将离开比赛。
见下文:
我想要数据来自的列被称为分配技术，它生活在协调表(源表)。
当我选择这一列后，被要求参考另一个表格在公式中出现:
协调表范围1
我想让数据出现的目标表叫做技术员收入表。
我希望数据出现的列被称为:
技术员的名字
数据将被输入协调表(来源表)，某些列需要在进入协调表时被填入技术人员收入表(目的表)。只要1对1拷贝就行了。
我尝试了上面的公式:
=指数({ColumnWithTheValueYouWantToShow};匹配((电子邮件保护)；{ColumnWithTheValueToMatchAgainsTheCell};0))但必须混淆语法或哪个列或单元格名称放在哪里。
很抱歉我理解得太慢了。
克里斯
0 -
heyjay ✭✭✭
![https:\/\/us.v-cdn.net\/6031209\/uploads\/O4WGGWDZB67A\/image.png<\/a><\/p>The destination sheet I want the data to appear in is called Technician Revenue Sheet.<\/p>The column I want the data to appear in is called:<\/p>Technician Name<\/p>https:\/\/us.v-cdn.net\/6031209\/uploads\/YK29AUB67NV0\/capture-png.png<\/a><\/p>The data will be entered into the Coordination Sheet (Source Sheet) and certain columns need to be populated on the Technician Revenue Sheet (Destination Sheet) as they are entered into the Coordination Sheet. It just needs to be 1 for 1 copy as it happens.<\/p>I tried the formula above:<\/p>=\nINDEX({ColumnWithTheValueYouWantToShow}; \nMATCH(CellThatHaveTheValueToMatch@row; {ColumnWithTheValueToMatchAgainsTheCell}; 0))\n<\/pre>But must be confused on the syntax or which Column or Cell name to put where.<\/p>I am sorry to be slow on the uptake here.<\/p>Chris<\/p>","bodyRaw":"[{\"insert\":\"In my main sheet, I have a lot of columns for a lot of different irrelevant information for what I am trying to do.\\nI am trying to bring in just a few columns to the clean sheet to perform calculations and automations on.\\nFor instance, I want the Technician name, Coordinators name, activity performed and product activity was performed on brought over to the new sheet. \\nOnce in the new sheet, I want to populate an expected revenue column that will be determined by automations based on activity and product. I can do this, but I am having a hard time grasping the concept of syntax for the functions to copy the data to the revenue sheet in real time.\\nThe first recommendation above works well, but it seems to only apply to what is already in the sheet. When new rows are added to the doner sheet, it does not get carried over to the second sheet.\\nI tried understanding the syntax of the second suggestion. I ALMOST get it, but am still struggling.\\nBelow is what I have with screen captures. If I can get the syntax as it applies to my situation, My light bulb may come on and I will be off to the races.\\nSee Below:\\nThe column I want the data to come from is called Assigned Tech and it lives on the Coordination Sheet (Source Sheet).\\nWhen I select this column after being asked to reference another sheet in the formula it appears as:\\nCoordination Sheet Range 1\\n\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/O4WGGWDZB67A\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/O4WGGWDZB67A\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"The destination sheet I want the data to appear in is called Technician Revenue Sheet.\\nThe column I want the data to appear in is called:\\nTechnician Name\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/YK29AUB67NV0\\\/capture-png.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/YK29AUB67NV0\\\/capture-png.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"The data will be entered into the Coordination Sheet (Source Sheet) and certain columns need to be populated on the Technician Revenue Sheet (Destination Sheet) as they are entered into the Coordination Sheet. It just needs to be 1 for 1 copy as it happens.\\nI tried the formula above:\\n=\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"INDEX({ColumnWithTheValueYouWantToShow}; \"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"MATCH(CellThatHaveTheValueToMatch@row; {ColumnWithTheValueToMatchAgainsTheCell}; 0))\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"But must be confused on the syntax or which Column or Cell name to put where.\\nI am sorry to be slow on the uptake here.\\nChris\\n\"}]","format":"rich","dateInserted":"2022-04-30T14:14:25+00:00","insertUser":{"userID":147532,"name":"Chood","url":"https:\/\/community.smartsheet.com\/profile\/Chood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-05-26T19:28:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/327955#Comment_327955","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/327955#Comment_327955](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/O4WGGWDZB67A\/image.png\"){kind=link}
![https:\/\/us.v-cdn.net\/6031209\/uploads\/YK29AUB67NV0\/capture-png.png<\/a><\/p>The data will be entered into the Coordination Sheet (Source Sheet) and certain columns need to be populated on the Technician Revenue Sheet (Destination Sheet) as they are entered into the Coordination Sheet. It just needs to be 1 for 1 copy as it happens.<\/p>I tried the formula above:<\/p>=\nINDEX({ColumnWithTheValueYouWantToShow}; \nMATCH(CellThatHaveTheValueToMatch@row; {ColumnWithTheValueToMatchAgainsTheCell}; 0))\n<\/pre>But must be confused on the syntax or which Column or Cell name to put where.<\/p>I am sorry to be slow on the uptake here.<\/p>Chris<\/p>","bodyRaw":"[{\"insert\":\"In my main sheet, I have a lot of columns for a lot of different irrelevant information for what I am trying to do.\\nI am trying to bring in just a few columns to the clean sheet to perform calculations and automations on.\\nFor instance, I want the Technician name, Coordinators name, activity performed and product activity was performed on brought over to the new sheet. \\nOnce in the new sheet, I want to populate an expected revenue column that will be determined by automations based on activity and product. I can do this, but I am having a hard time grasping the concept of syntax for the functions to copy the data to the revenue sheet in real time.\\nThe first recommendation above works well, but it seems to only apply to what is already in the sheet. When new rows are added to the doner sheet, it does not get carried over to the second sheet.\\nI tried understanding the syntax of the second suggestion. I ALMOST get it, but am still struggling.\\nBelow is what I have with screen captures. If I can get the syntax as it applies to my situation, My light bulb may come on and I will be off to the races.\\nSee Below:\\nThe column I want the data to come from is called Assigned Tech and it lives on the Coordination Sheet (Source Sheet).\\nWhen I select this column after being asked to reference another sheet in the formula it appears as:\\nCoordination Sheet Range 1\\n\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/O4WGGWDZB67A\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/O4WGGWDZB67A\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"The destination sheet I want the data to appear in is called Technician Revenue Sheet.\\nThe column I want the data to appear in is called:\\nTechnician Name\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/YK29AUB67NV0\\\/capture-png.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/YK29AUB67NV0\\\/capture-png.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"The data will be entered into the Coordination Sheet (Source Sheet) and certain columns need to be populated on the Technician Revenue Sheet (Destination Sheet) as they are entered into the Coordination Sheet. It just needs to be 1 for 1 copy as it happens.\\nI tried the formula above:\\n=\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"INDEX({ColumnWithTheValueYouWantToShow}; \"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"MATCH(CellThatHaveTheValueToMatch@row; {ColumnWithTheValueToMatchAgainsTheCell}; 0))\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"But must be confused on the syntax or which Column or Cell name to put where.\\nI am sorry to be slow on the uptake here.\\nChris\\n\"}]","format":"rich","dateInserted":"2022-04-30T14:14:25+00:00","insertUser":{"userID":147532,"name":"Chood","url":"https:\/\/community.smartsheet.com\/profile\/Chood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-05-26T19:28:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/327955#Comment_327955","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/327955#Comment_327955](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/YK29AUB67NV0\/capture-png.png\"){kind=link}