In timeline view, how can I keep the same order on the grid when grouping by category

Alicia D

In the new timeline view, I have created a column called "title" so that I can group by each category. However, when I do this it puts the categories in alphabetical order and not the order that it displays in the grid view. How can I change this? For instance, introduction and several other things should come before configuration.

Matt Lynn ACT

@Alicia D

Try this: Change your new column called "title" to a drop down menu and put the options in the order that you want to see them within the drop down options. On my sheet, the grouping is sorted in the same order as my drop down options.

Matt Lynn ACT

@Alicia D

Option 1 (Formula I originally provided as a column formula)

=IFERROR(INDEX(ANCESTORS(Task@row), 1), Task@row)

Result:

Option 2

=IFERROR(INDEX(PARENT(Task@row), 1), Task@row)

Result:

Matt Lynn ACT

@Alicia D

Try this: Change your new column called "title" to a drop down menu and put the options in the order that you want to see them within the drop down options. On my sheet, the grouping is sorted in the same order as my drop down options.

Alicia D

@Matt Lynn-PCG , this worked, thank you! I am curious if you might know if there is a way to set a formula in the title column so that it populates all of the sub rows to be the same as the parent row so that I don't have to enter the corresponding dropdown every time a new line is created

Matt Lynn ACT

@Alicia D

=IFERROR(INDEX(ANCESTORS(Task@row), 1), Task@row)

Alicia D

When I use this formula, it changes to the main parent row, and not the sub parent row. Is there a way to have it pull from its direct parent row and not the highest level? @Matt Lynn-PCG

Matt Lynn ACT

@Alicia D

Option 1 (Formula I originally provided as a column formula)

=IFERROR(INDEX(ANCESTORS(Task@row), 1), Task@row)

Result:

Option 2

=IFERROR(INDEX(PARENT(Task@row), 1), Task@row)

Result:

Alicia D

Thank you!