Can i move child rows to another sheet and copy the parent row across too?

Luka

At the end of each quarter, i'd like to copy parent rows and move the previous 3 months (from each parent row) to an archive sheet. Is this possible?

I'd then like to have an automation after this that adds 3 new rows under each parent row once a new quarter begins.

Paul Newcome

Are you able to provide screenshots for context?

Luka

For example, these months are just 2024 months. Once we hit Q1 2025, I'd like 2024 Q1 rows to move to an archive sheet (along with the parent row being copied), and for 2025 Q1 rows to be added below 2024 Q4 rows. Is this possible?

Ward.Hively

Luka,

Child rows always follow the parent row when a move or copy rows automation is executed.

Rarely have I seen a viable move-copy rows workflow with hierarchies. Initially, it seems effective but quickly turns into a mess.

I would recommend keeping the data on a single sheet and adding an automation to check a box for each of the rows you have specified.

If you are archiving to remove from metrics on a dashboard, this will give you the ability to filter the rows from a report or isolate them from a formula without overcomplicating the sheet.

Hope this helps Luka!

Luka

Hi Ward,

Thanks for clarifying. How would i add an automation to insert new rows for the quarter ahead, under each parent row and with all month names included? Is that possible?

Thanks.