Smartsheet: Sort by Parent (Ignore Children)

Today’s Tip (2018-08-03): Based on this Community Post.

The user wanted to sort a hierarchy, but only on the Parent Row.

Here’s how:

I created a column named [Sort Order].

I added this formula:

=IF(COUNT(ANCESTORS()) = 0, [Primary Column]@row, COUNT(ANCESTORS()))

to each cell.

It checks if this is a Parent Row (COUNT(ANCESTORS()) = 0) and if it is, it returns the value of the [Primary Column] and if not, returns the ancestor count.

Since Smartsheet sorts by each hierarchy level in turn, since all of the rows at a particular level EXCEPT the Parent, will not sort at all.

Lots of ways to expand this, but knowing there is a solution is the start of that.








Thank you so much for providing this. Our project requires many Parents, Children and so on, but the filtering of 2500+ sheets requires many filters/sorting in order to see what we need when all that was needed was this simple trick. Again thank you for providing this.

Write a Reply or Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.