Automatically import data from one sheet to another?
I'm finding a few different answers but not sure which one pertains to my situation exactly. I have created a smartsheet with a form that is an application for students to apply to be a part of a team. I then have a second smartsheet where their applications will be scored. Is there a way to send certain data (not all) from the first sheet (application) automatically to the second sheet (scoring) as it comes in?
I know I can link the cells, but to my knowledge, I would have to go in and link each individual column and it wouldn't be automatic. I'd have to update manually every so often. I've also read about formulas but none of them seem to apply to my exact situation.
Is this possible or no? If so, how, please?
Best Answer
-
You can make an automation to move rows from one sheet to another, Unfortunately it will copy over the other information but you can hide those columns on your second sheet.
1) Automation is located in top left corner
2) Create flow from template
3) Choose " Move a row to another sheet when specified criteria are met" template.
4) Follow steps to choose criteria and sheet destination.
5) That should be it, test automation once.
Ricky T
Gov Contractor for USSF
Answers
-
You can make an automation to move rows from one sheet to another, Unfortunately it will copy over the other information but you can hide those columns on your second sheet.
1) Automation is located in top left corner
2) Create flow from template
3) Choose " Move a row to another sheet when specified criteria are met" template.
4) Follow steps to choose criteria and sheet destination.
5) That should be it, test automation once.
Ricky T
Gov Contractor for USSF
-
i can definitely make that work! Thank you!
-
This is a great feature, choosing the "Move a row to another sheet when specified criteria are met" template from automation.
However, I believe it should only copy/move data from Sheet A to Sheet B where the column names match. Currently, it is copying other columns from Sheet A to Sheet B as well.
Is there any workaround for the same?
-
Following this because I have the same question - I do not want to move all rows, only matching column names.
-
As I am also looking for a solution, meanwhile I can suggest two workarounds:
- To avoid moving all rows:
- Create a new checkbox column.
- Create automation workflow when "Only the rows that are checked need to copied or moved to the destination sheet."
- For matching column names:
- Hide the columns that do not need to be visible in sheet
- To avoid moving all rows:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!