Copy Rows to Another Sheet
Answers
-
Are the cells on the same row? You can use a copy to workflow, then hide the extraneous columns.
-
Hi Jane,
You can either use the copy row automation or a VLOOKUP or INDEX/MATCH formula.
Would any of those options work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I commented that the hide columns solutions would not work, but that turned out to be easier way to deal with this issue. I do have a question about the VLOOKUP or INDEX/MATCH formulas. It appears that a specific row needs to be identified, when I am looking for a copy function when a new row is added to the "copy from" sheet. Would either of those work for a new row copy?
-
Yes. Index match is a faster and more versatile version of Vlookup, but they both perform the same function, so you can use either, but I recommend learning index match.
To handle new rows you need to use column references rather than row references.
an example where the columns name is "A" would be:
row reference:
A1:A20
Column reference:
A:A
-
I saw that it got answered already!
Let me know if I can help with anything else!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Is it not possible to just Ctrl-C and Ctrl-V the contents of a cell or cells from one sheet to another?
-
Hi @JohnGM
I hope you're well and safe!
In most cases, it should work just fine to copy/paste.
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives