Move child row under new parent row when a cell value is changed.

TaylorBaker

I have parent rows (upcoming week, current week, and past weeks) and I'd like to be able to change the status cell from upcoming week to current week, and have it move the row under a different parent row. Is this possible?

Archiduc

I don't think can move automatically in the sheets, but if you use a report and group by status that might do what you're trying to achieve?