复制行自动化—只复制某些列?
答案
-
她名叫Stara ✭✭✭✭✭✭你好戈登,
不幸的是，现在还不能选择要包括哪些列(马上就会有)，但这是一个很好的主意!
正如您提到的，作为一种可能的变通方法，您可以使用交叉表格公式，但您需要有一些惟一的标识符。
会工作吗?
我希望这对你有帮助!
注意安全，祝你度过美好的一周!
最好的
她名叫Stara
工作流程顾问/ CEO @工作大胆
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请帮助社区将其标记为可接受的答案/有用的答案．这将使别人更容易找到解决方案或帮助回答!
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
如果您需要Smartsheet、集成、一般工作流建议或其他方面的帮助，请随时与我联系。
1 -
ipeat ✭(它的),
快越好
0 -
特里·刘易斯 ✭✭✭✭✭✭
难道你不能只允许复制整个行，而将源工作表中的“额外”列放在目标工作表的右侧吗?然后可以隐藏这些额外的列并忽略它们。
0 -
克里斯汀科朗格洛 ✭
你能尽快做这个增强吗?我的公司可以好好利用这一点。我试图让大多数团队和部门开始使用智能表，如果这种增强发生，那么它将使我的团队更容易想要使用这个。谢谢! ! !
Ps -已经填写了请求增强表单:)
0 -
她名叫Stara ✭✭✭✭✭✭
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
如果您需要Smartsheet、集成、一般工作流建议或其他方面的帮助，请随时与我联系。
0 -
斯蒂芬妮Tran ✭✭✭✭✭✭这个特性什么时候会出来?
1 -
凯文·斯科特 ✭0
-
她名叫Stara ✭✭✭✭✭✭
嗨@Stephanie Tran，@Kevin斯科特，@Terry刘易斯，@Gordon＆@ipeat．
我希望你平安无事!
这里有一个可能的解决方法
您可以使用交叉工作表公式结合VLOOKUP或INDEX/MATCH结构来连接工作表，当您更新源工作表时，它将反映在目标工作表上。
另一种选择是使用所谓的助手表。简而言之，将行复制到帮助表中，然后使用我前面描述的方法将需要的值复制到另一个帮助表中，然后将该行从该工作表复制/移动到主目标工作表中。
工作/帮助吗?
我希望这对你有帮助!
注意安全，祝你度过美好的一周!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区通过将其标记为有洞察力/投票支持或/和作为公认的答案．这将使别人更容易找到解决方案或帮助回答!
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
如果您需要Smartsheet、集成、一般工作流建议或其他方面的帮助，请随时与我联系。
0 -
罗兰·霍尔伍德中校 ✭✭✭✭✭✭嗯,
将是一个非常有用的功能，更新多个，但不同的表，当一个新的行添加到“主”表，没有得到所有列你不想要…我希望它能在某个时候作为一个功能出现
0 -
布雷特埃里克 ✭✭✭✭大家好,
我不是要提一个几个月前的帖子，只是想说，如果你使用Smartsheet以外的服务，这是可行的。
就我个人而言，我利用微软的电力自动化(类似于Zapier，Automate.io等)来实现您想要的自定义自动化。如果有人感兴趣，我可以教你怎么做如果您已经订阅了Power Automate。我相信我能找到办法让它在Zapier或其他服务中运行。
如果这个答案回答了你的问题，请按上面的“是”-它有助于社区(和那些随机的谷歌人在那里)找到像你这样的解决方案更快。
布雷特埃里克;您友好的社区自由顾问和Smartsheet助手。
❓需要更多帮助吗?想要自动化智能表之外的系统以连接到您的智能表?想让您的报表自动化，从而更容易地相互交谈吗?其他问题吗?给我发邮件或在LinkedIn上和我联系．
0
类别
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":[]}">
