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

  • David Tutwiler
    David Tutwiler Overachievers Alumni

    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

  • lora.riggs
    lora.riggs ✭✭✭

    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.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!