Automated Workflow: Move Rows & Parent/Child Structure?

Hi!

I have a contract management sheet where I have individual years within a contract broken out as child rows underneath the parent contract.

I would like to be able to automate a workflow to move the individual rows to an archive sheet when the year is over, but I'm not sure how to do that while keeping the parent-child structure. Is that possible? If so, any tips?

Thanks! ~Jennifer

Answers