Copy Row Automation & Parent/Child relationships.

OK, looking for some inventive ideas here.

I have a budget sheet and a schedule sheet with a copy row automation, obviously this just copies to the bottom of the sheet, then I need to move each row manually to the right category, a.k.a below the correct parent row, in the schedule.

Does anyone have any inventive ideas, maybe using formulas, a zap or something like that so that the row moves to the correct location on the schedule....


Please no "Smartsheet doesn't support that" comments, I already know that and I'm looking for a work around.


Cheers,


Adam.

Answers