Archiving a Child row with it's parent row.

Hammermill21

Hello everyone!

I want to set up a workflow where I move a row when it check off as archived. But that row is a child of a parent row. How can I move both the child and parent row from my sheet, but also not actually remove the parent row from the master sheet?

Thank you!

Andrée Starå

Hi,

Unfortunately, it's not possible at the moment to keep the hierarchy when moving/copying to another sheet, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment to have your vote added

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi,

Unfortunately, it's not possible at the moment to keep the hierarchy when moving/copying to another sheet, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment to have your vote added

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Hammermill21

HI Andree,

Thank you. I think I found a workaround for it.

Have a great weekend!

Andrée Starå

Excellent!

Happy to help!

How did you solve it?

It would be great If you'd like to share the solution so it can help others with similar needs.

Hammermill21

I didn't "solve" it necessarily but what I did was create a column that is hidden and added the formula =PARENT([Task Name]3) on each row. That way I have the Parent Task on the same row of the task.

I'm not sure if that makes sense!

Andrée Starå

Ok.

Glad you got it working!

Pro-tip: If you use =PARENT([Task Name]@row instead it will show the parent for that row instead. No need to think about which row number it is. Make sense?

Hammermill21

Yes it does! Thank you so much :)

Andrée Starå

You're more than welcome!

A Rose

Hey @Andrée Starå

Is it still the case? still not possible to keep the hierarchy when moving/copying to another sheet?

Got any advice with such rows for archiving purposes or for other projects use?

Thanks,

Erin Kim

@A Rose wondering the same thing @Andrée Starå - Thanks!