复制行自动化—只复制某些列?

戈登
戈登 ✭✭✭✭✭✭
编辑06/29/20 在内容基本知识

当触发复制行自动化时，是否有一种方法只复制该行中的某些列/单元格?

如果没有，是否有办法获取输出工作表数据并交叉引用到第三个工作表中的匹配行，以及是否可以在目标工作表之外构建进一步的自动化?

答案

  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    你好戈登,

    不幸的是，现在还不能选择要包括哪些列(马上就会有)，但这是一个很好的主意!

    有时间请提交增强请求

    正如您提到的，作为一种可能的变通方法，您可以使用交叉表格公式，但您需要有一些惟一的标识符。

    会工作吗?

    我希望这对你有帮助!

    注意安全，祝你度过美好的一周!

    最好的

    她名叫Stara

    工作流程顾问/ CEO @工作大胆

    ✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请帮助社区将其标记为可接受的答案/有用的答案．这将使别人更容易找到解决方案或帮助回答!

    Smartsheet专家顾问和合作伙伴

    https://workbold.com/

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

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    如果您需要Smartsheet、集成、一般工作流建议或其他方面的帮助，请随时与我联系。

  • ipeat
    ipeat ✭

    (它的),

    快越好

  • 特里·刘易斯
    特里·刘易斯 ✭✭✭✭✭✭

    难道你不能只允许复制整个行，而将源工作表中的“额外”列放在目标工作表的右侧吗?然后可以隐藏这些额外的列并忽略它们。

  • 克里斯汀科朗格洛
    克里斯汀科朗格洛 ✭

    @Andree Stara

    你能尽快做这个增强吗?我的公司可以好好利用这一点。我试图让大多数团队和部门开始使用智能表，如果这种增强发生，那么它将使我的团队更容易想要使用这个。谢谢! ! !


    Ps -已经填写了请求增强表单:)

  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    嗨@Kristen科朗格洛

    如果可以我会的，但我不是智能表的员工。

    我是Smartsheet合伙人/顾问。

    注意安全，祝你度过美好的一周!

    最好的

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

    Smartsheet专家顾问和合作伙伴

    https://workbold.com/

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

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    如果您需要Smartsheet、集成、一般工作流建议或其他方面的帮助，请随时与我联系。

  • 斯蒂芬妮Tran
    斯蒂芬妮Tran ✭✭✭✭✭✭

    这个特性什么时候会出来?

  • 凯文·斯科特
    凯文·斯科特 ✭

    @Stephanie Tran你的问题得到答复了吗?

    我也有同样的问题，同样的需求……希望使用工作流自动化将一行复制到另一个工作表，但只包括列的子集。

    请让我们知道是否有这个功能的可用性的更新。

  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    嗨@Stephanie Tran，@Kevin斯科特，@Terry刘易斯，@Gordon＆@ipeat．

    我希望你平安无事!

    这里有一个可能的解决方法

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

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

    工作/帮助吗?

    我希望这对你有帮助!

    注意安全，祝你度过美好的一周!

    最好的

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

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

    Smartsheet专家顾问和合作伙伴

    https://workbold.com/

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

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    如果您需要Smartsheet、集成、一般工作流建议或其他方面的帮助，请随时与我联系。

  • 罗兰·霍尔伍德中校
    罗兰·霍尔伍德中校 ✭✭✭✭✭✭

    嗯,


    将是一个非常有用的功能，更新多个，但不同的表，当一个新的行添加到“主”表，没有得到所有列你不想要…我希望它能在某个时候作为一个功能出现

  • 布雷特埃里克
    布雷特埃里克 ✭✭✭✭

    大家好,

    我不是要提一个几个月前的帖子，只是想说，如果你使用Smartsheet以外的服务，这是可行的。

    就我个人而言，我利用微软的电力自动化(类似于Zapier，Automate.io等)来实现您想要的自定义自动化。如果有人感兴趣，我可以教你怎么做如果您已经订阅了Power Automate。我相信我能找到办法让它在Zapier或其他服务中运行。

    如果这个答案回答了你的问题，请按上面的“是”-它有助于社区(和那些随机的谷歌人在那里)找到像你这样的解决方案更快。

    布雷特埃里克;您友好的社区自由顾问和Smartsheet助手。

    ❓需要更多帮助吗?想要自动化智能表之外的系统以连接到您的智能表?想让您的报表自动化，从而更容易地相互交谈吗?其他问题吗?给我发邮件或在LinkedIn上和我联系．‎

类别

Hi @Kaleb Riley<\/a><\/p>

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

Have you checked the zoom level?<\/p>

You could also test log out\/in and test another browser.<\/p>

Did 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>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-02 11:57:16","updateUser":{"userID":143030,"name":"Kaleb Riley","url":"https:\/\/community.smartsheet.com\/profile\/Kaleb%20Riley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-02T12:05:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":219,"urlcode":"Sheets","name":"Sheets"}]},{"discussionID":94966,"type":"question","name":"If I deactivate a licensed user, does their license return to the pool of available licenses?","excerpt":"I am the System Admin on an Enterprise plan. If I deactivate a licensed user, does their license return to the pool of available licenses? It still shows them as licensed in User Management, and I can't make any changes to the user without reactivating them.","categoryID":321,"dateInserted":"2022-09-01T15:41:39+00:00","dateUpdated":null,"dateLastComment":"2022-09-01T16:55:21+00:00","insertUserID":86866,"insertUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2022-09-01T16:53:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":86866,"lastUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2022-09-01T16:53:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":41,"score":null,"hot":3324099420,"url":"https:\/\/community.smartsheet.com\/discussion\/94966\/if-i-deactivate-a-licensed-user-does-their-license-return-to-the-pool-of-available-licenses","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94966\/if-i-deactivate-a-licensed-user-does-their-license-return-to-the-pool-of-available-licenses","format":"Rich","lastPost":{"discussionID":94966,"commentID":342070,"name":"Re: If I deactivate a licensed user, does their license return to the pool of available licenses?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/342070#Comment_342070","dateInserted":"2022-09-01T16:55:21+00:00","insertUserID":86866,"insertUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2022-09-01T16:53:04+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-01T16:53:29+00:00","dateAnswered":"2022-09-01T16:06:31+00:00","acceptedAnswers":[{"commentID":342056,"body":"

Yes, the user you deactivate will no longer have access to the account, but you will not have to transfer ownership of their items and their license will become available again. You have to be careful though, if you reassign that license that user comes back needing one then you will have to make an executive decision on who gets one and who doesn't.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-01 16:53:29","updateUser":{"userID":86866,"name":"Jeff Reisman","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Reisman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3V8W2AM105QE\/nIDXI4I7VDS7W.JPG","dateLastActive":"2022-09-01T16:53:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}}},"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":[]},{"discussionID":94961,"type":"question","name":"How can I use Smartsheet to create Surveys?","excerpt":"I need to get some feedback from a customer group and I want to use Smartsheet to conduct a survey. Has anyone done this?","categoryID":321,"dateInserted":"2022-09-01T14:50:51+00:00","dateUpdated":"2022-09-01T14:52:00+00:00","dateLastComment":"2022-09-01T16:00:37+00:00","insertUserID":151981,"insertUser":{"userID":151981,"name":"GMay","url":"https:\/\/community.smartsheet.com\/profile\/GMay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-03T19:13:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":151981,"lastUserID":151981,"lastUser":{"userID":151981,"name":"GMay","url":"https:\/\/community.smartsheet.com\/profile\/GMay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-03T19:13:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3324093088,"url":"https:\/\/community.smartsheet.com\/discussion\/94961\/how-can-i-use-smartsheet-to-create-surveys","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94961\/how-can-i-use-smartsheet-to-create-surveys","format":"Rich","lastPost":{"discussionID":94961,"commentID":342055,"name":"Re: How can I use Smartsheet to create Surveys?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/342055#Comment_342055","dateInserted":"2022-09-01T16:00:37+00:00","insertUserID":151981,"insertUser":{"userID":151981,"name":"GMay","url":"https:\/\/community.smartsheet.com\/profile\/GMay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-03T19:13:28+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-01T15:58:15+00:00","dateAnswered":"2022-09-01T15:27:24+00:00","acceptedAnswers":[{"commentID":342048,"body":"

Hi @GMay<\/a> <\/p>

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

You could use a form with the questions or the Update Request feature.<\/p>

Would any of those options 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>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-01 15:58:15","updateUser":{"userID":151981,"name":"GMay","url":"https:\/\/community.smartsheet.com\/profile\/GMay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-03T19:13:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">