
Sort by Parent Values Without Changing Order of Children Rows
August 2, 2018 9:36 am
0
I have multiple tasks each with multiple sub-tasks. The tasks and sub-tasks are not in alpha order, for example:
Whether I leave the rows expanded or collapsed, when I sort the rows by task, it sorts the task and the sub-tasks, like so:
However, now the sub-tasks are out of their correct logical order, e.g., analyze data before gather data.
How do I sort based on the value in the parent row (Acme, Beta, Gamma) without that also applying to the children rows? Is the only way to put the sub-tasks in a new column, e.g., to the right of the task? Seems like needless column-proliferation, especially as on my actual sheet I have 2 or even 3 more levels down below the sub-tasks and not all sub-tasks have any or the same number of sub-levels.
Help is greatly appreciated.
Comments
Elliot Raff
August 2, 2018 9:39 am
Elliot Raff
August 2, 2018 9:49 am
Andrée Starå
August 2, 2018 11:09 am
Elliot Raff
August 2, 2018 12:28 pm
In reply to Hi Elliot, It sounds to me… by Andrée Starå
J. Craig Williams
August 3, 2018 7:43 am
J. Craig Williams
August 3, 2018 8:37 am