In timeline view, how can I keep the same order on the grid when grouping by category
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.
Best Answers
-
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.
-
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:
Answers
-
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-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
-
=IFERROR(INDEX(ANCESTORS(Task@row), 1), Task@row)
-
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
-
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:
-
Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives