Live copy of datasheet

Maxwony

Is it possible to make a live copy of a datasheet. When new rows are entered on the original, will the copy update? I also would like to add additional information to this copy, but I don't want information I entered on the copy to affect the original.

Katy H

You can create a copy row automation to copy rows from the original datasheet into the copy. The automation should live in the source sheet not the copy to prevent data from being copied back to the other. There will be a slight delay but it will copy over.

https://help.smartsheet.com/articles/2479626-automatically-move-or-copy-rows-between-sheets

Katy H

You can create a copy row automation to copy rows from the original datasheet into the copy. The automation should live in the source sheet not the copy to prevent data from being copied back to the other. There will be a slight delay but it will copy over.

https://help.smartsheet.com/articles/2479626-automatically-move-or-copy-rows-between-sheets

Andrée Starå

Hi @Maxwony

I hope you're well and safe!

To add to Katy's excellent advice/answer.

Another option,

• 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.

Would that 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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!