Sorting Parent rows but not child rows

Is it possible to sort just the Parent rows but not the child rows? Our parent rows need to be sorted in alpha order however our child rows are in order of task and we don't want them to be sorted.
Answers
-
Hi @DeniseMetz
If you want to sort with the top-level parent, you can add a helper column like this;
[Top Parent] =IF(COUNT(ANCESTORS()) = 0, [Primary Column]@row, INDEX(ANCESTORS(), 1))
Then, sort the sheet with the column.
(Link to the editable published sheet)
After the Top Parent Sort.
As you can see, the 2nd level parents and their children keep the original order.
Experiment
I experimented with sorting by the primary column.
After the sort
The experiment shows that after sorting, though the parent-child relationship or hierarchy is intact, all the rows are sorted alphabetically.
I did not know this "sort behavior" of the primary column. It's interesting.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives