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
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives