Can you move Completed Tasks to a different sheet while copying their Parent to the sheet?
I manage 20+ projects and have a master tracker sheet that is used in our weekly status updates with the team. The way we manage tasks is creating children of each project, where each project is a parent. There would be hundreds of tasks throughout the lifetime of the project, and ideally I could check off that they are complete and they can move to a "Completed Task Archive" while retaining a connection with the Parent Project.
Is this possible?