将特定列从一个工作表复制到另一个工作表(链接)

她名叫Stara · 02/23/23

嗨@Molly杨

我希望你一切安好!

您可以使用与VLOOKUP或INDEX/MATCH结构相结合的交叉表公式来连接工作表，并且当您更新源工作表时，它将反映在目标工作表上。

另一种选择是使用所谓的帮助表。简而言之，将该行复制到一个帮助表，然后使用我前面描述的方法将所需的值获取到另一个帮助表，然后将该行从该工作表复制/移动到主要目标工作表。

这样行吗?

我希望这对你有帮助!

注意安全，祝你一周愉快!

最好的

她名叫Stara|工作流程顾问/ CEO @工作大胆

✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为“有见地”/“投票赞成”、“很棒”或“并且”作为公认的答案。这将使其他人更容易找到解决方案或帮助回答!

丹尼尔•威尔逊 · 02/23/23

@Molly杨如果您不像Sam上面所说的那样需要行上的附件，并且每行都有一个唯一标识符(比如审计号)，那么您可以考虑这样做DataMesh！

莫莉杨 · 02/24/23

@Molly Yang <\/a> If you don't to Sam's point above need attachments on the row and have a unique identifier per row (like an audit number) you might consider DataMesh<\/a>!<\/p>","bodyRaw":"[{\"insert\":{\"mention\":{\"name\":\"Molly Yang \",\"userID\":158647}}},{\"insert\":\" If you don't to Sam's point above need attachments on the row and have a unique identifier per row (like an audit number) you might consider \"},{\"attributes\":{\"link\":\"https:\\\/\\\/www.santa-greenland.com\\\/marketplace\\\/premium-apps\\\/datamesh\"},\"insert\":\"DataMesh\"},{\"insert\":\"!\\n\"}]","format":"rich","dateInserted":"2023-02-23T13:07:33+00:00","insertUser":{"userID":152988,"name":"Danielle Wilson","url":"https:\/\/community.smartsheet.com\/profile\/Danielle%20Wilson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZZDXWctIdZQ!BrDQwSiqPOQ!J3oBfQ3Wq2i","dateLastActive":"2023-06-22T22:32:12+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/363869#Comment_363869","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/363869#Comment_363869

Hi Product Team: <\/p>

I have been copying rows in between two sheets (audit plan and audit summary), when the planned audit date is in the past, copy the row to audit summary sheet for the team to update the audit result; when the audit expiration date achieves, to copy the row back to audit plan sheet for the team to plan another audit before it's expired. <\/p>

I don't need all the columns to be copied to the other sheets, it would be great if SMARTSHEET can create solution for me to only move the columns required. Currently, it's confusing for having too many unecessary columns and also I got to create automation to move the old data so that new data entries could be allowed. Not ideal!!! <\/p>

Thanks.<\/p>","bodyRaw":"[{\"insert\":\"Hi Product Team: \\nI have been copying rows in between two sheets (audit plan and audit summary), when the planned audit date is in the past, copy the row to audit summary sheet for the team to update the audit result; when the audit expiration date achieves, to copy the row back to audit plan sheet for the team to plan another audit before it's expired. \\nI don't need all the columns to be copied to the other sheets, it would be great if SMARTSHEET can create solution for me to only move the columns required. Currently, it's confusing for having too many unecessary columns and also I got to create automation to move the old data so that new data entries could be allowed. Not ideal!!! \\nThanks. \\n\"}]","format":"rich","dateInserted":"2023-02-23T07:51:59+00:00","insertUser":{"userID":158647,"name":"Molly Yang ","url":"https:\/\/community.smartsheet.com\/profile\/Molly%20Yang%20","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-24T08:11:24+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\/363853#Comment_363853","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/363853#Comment_363853

@Danielle威尔逊如果你有时间，我想分享一下我的工作，我不相信上面提到的函数可以解决问题。非常感谢。

莫莉杨 · 02/24/23

Hi @Molly Yang <\/a> <\/p>

I hope you're well and safe!<\/p>

You could use cross-sheet formulas combined with either a VLOOKUP or INDEX\/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.<\/p>

Another option would be to use so-called helper sheets. In short, copy the row to a helper sheet and then use my method described previously to get the values you need to another helper sheet and then copy\/move the row from that sheet to the main destination sheet. <\/strong><\/p>

Would that work\/help? <\/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>","bodyRaw":"[{\"insert\":\"Hi \"},{\"insert\":{\"mention\":{\"name\":\"Molly Yang \",\"userID\":158647}}},{\"insert\":\" \\nI hope you're well and safe!\\nYou could use cross-sheet formulas combined with either a VLOOKUP or INDEX\\\/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.\\nAnother option would be to use so-called helper sheets. \"},{\"attributes\":{\"bold\":true},\"insert\":\"In short, copy the row to a helper sheet and then use my method described previously to get the values you need to another helper sheet and then copy\\\/move the row from that sheet to the main destination sheet. \"},{\"insert\":\"\\nWould that work\\\/help? \\nI hope that helps!\\nBe safe, and have a fantastic week!\\nBest,\\n\"},{\"attributes\":{\"bold\":true,\"link\":\"mailto:andree@workbold.com\"},\"insert\":\"Andrée Starå\"},{\"insert\":\" | Workflow Consultant \\\/ CEO @ \"},{\"attributes\":{\"bold\":true,\"link\":\"https:\\\/\\\/workbold.com\\\/\"},\"insert\":\"WORK BOLD\"},{\"insert\":\"\\n✅\"},{\"attributes\":{\"italic\":true},\"insert\":\"Did my post(s) help or answer your question or solve your problem? Please support the Community by \"},{\"attributes\":{\"italic\":true,\"bold\":true},\"insert\":\"marking it Insightful\\\/Vote Up, Awesome, or\\\/and as the accepted answer\"},{\"attributes\":{\"italic\":true},\"insert\":\". It will make it easier for others to find a solution or help to answer!\"},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2023-02-23T10:00:26+00:00","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-23T12:13:23+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\/363834#Comment_363834","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/363834#Comment_363834

@Andree Stara谢谢，不幸的是，这不会解决问题，我的工作流程是不同的。谢谢

她名叫Stara · 02/24/23

@Molly杨

好的。很乐意帮忙!

丹尼尔•威尔逊 · 02/25/23

@Molly杨我建议与你的客户团队联系，讨论选择或预订箴桌子讨论选项和DataMesh，如果您的帐户上有Pro Desk !

迦勒。 · 03/03/23

这将是非常有用的!我目前正在将一个巨大的文件从Excel转换到Smartsheet。由于Smartsheet表尺寸的限制，我现在必须有多个表的创意。允许列复制到另一个工作表，而不必复制整个行将帮助这么多!

EmmaHill · 03/09/23

我要求能够创建一个自动化，您可以将单个单元格复制到新表。目前有一个自动化复制整个行到另一个表，但这是没有帮助的，如果表结构是不一样的。

VLD · 04/03/23

是否可以移动一行的某些列而不是整行，即，如果我有10行数据列a, B, C, D，我只想从所有行移动列a和D到另一个表。

希望这能说得通?

丹尼尔•威尔逊 · 04/03/23

@VLD是的，你可以用DataMesh如果每行有唯一标识符

VLD · 04/03/23

@Danielle威尔逊谢谢你，我没有必要的访问权限，但很高兴知道有这个工具。我会记住这一点，看看我是否能得到这个提供给我在我的业务。

她名叫Stara · 04/03/23

嗨@VLD

我希望你一切安好!

这里有一个或多个可能的解决方案

您可以使用与VLOOKUP或INDEX/MATCH结构相结合的交叉表公式来连接工作表，并且当您更新源工作表时，它将反映在目标工作表上。

另一种选择是使用所谓的帮助表。简而言之，将该行复制到一个帮助表，然后使用我前面描述的方法将所需的值获取到另一个帮助表，然后将该行从该工作表复制/移动到主要目标工作表。

这样行吗?

我希望这对你有帮助!

注意安全，祝你一周愉快!

最好的

她名叫Stara|工作流程顾问/ CEO @工作大胆

✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为“有见地”/“投票赞成”、“很棒”或“并且”作为公认的答案。这将使其他人更容易找到解决方案或帮助回答!

VLD · 04/03/23

@Andree Stara谢谢，我刚刚找到INDEX，正在使用它。是INDEX让我觉得一定还有别的办法，现在我知道了。再次感谢你，我会尝试你的建议。

她名叫Stara · 04/03/23

@VLD

太好了!

很乐意帮忙!

✅记住!我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为有洞察力/投票赞成/很棒或/和作为公认的答案。这将使其他人更容易找到解决方案或帮助回答!

OORF · 04/07/23

目前，我使用自动化在满足触发器时复制或移动行，但是在很多情况下，并非需要所有列。这将有助于自动化，您可以选择要移动或复制的列，而不必复制/移动整行信息。

登录提交新的想法和投票

将特定列从一个工作表复制到另一个工作表(链接)

评论

类别