Pull a row from another sheet.
Hello,
I was wondering is someone could help me with a formula.
I would like to have a range of rows from one sheet to replicate in another.
e.g
Sheet 1
Row 3 - Dataset1
Row 4 - Dataset2
Row 5 - Dataset3
Row 6 - Blank
Row 7 - Blank
Sheet 2
Row 10 = Dataset1 from Sheet 1
Row 11 = Dataset2 from Sheet 1
Row 12 = Dataset3 from Sheet 1
Row 13 = Blank (matching Sheet 1)
Row 14 = Blank (matching Sheet 1)
At a later date, row 6 is populated in Sheet 1 and then it looks like this:
Sheet 1
Row 3 - Dataset1
Row 4 - Dataset2
Row 5 - Dataset3
Row 6 - Dataset4
Row 7 - Blank
Sheet 2
Row 10 = Dataset1 from Sheet 1
Row 11 = Dataset2 from Sheet 1
Row 12 = Dataset3 from Sheet 1
Row 13 = Dataset4 from Sheet 1
Row 14 = Blank (matching Sheet 1)
What formulas can I write in Sheet 2 to pull the rows from Sheet 1?
I hope this makes sense?
Thanks
Answers
-
I think you can achieve this without writing any formulas. If you go into your source sheet and select Automation, you should be able to create a workflow that does this. All you would need to do is have the triggered condition be whatever indicates that the row needs to be copied to another sheet, and then use the Copy Row action and point it to your second sheet. This should give you the functionality you're looking for.
Does that get you what you need? Below is an article on the Copy Row feature:
-
Greetings,
I think you are correct, the bummer and I have seen some grumblings on this, is that there is not a way to sort automatically. So, what will happen, is that the row will copy over at the top of the sheet. Sorting has to be done manually each time data comes over. This is not the end of the world but it is not an automation, it is a partial automation partial manual process.
Thanks for the information
Marc
-
I see a lot of threads about pulling data from another sheet, but I am still unclear on where to place the reference to the other sheet in my formula.
-
Hi @lora.riggs
I hope you're well and safe!
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.
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.
To connect them row by row, you'd use an Autonumber Column in the Source sheet and add a so-called helper column to manually add the row id on as many rows as you think you need in the Destination sheet.
More info.
Would that work/help?
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!