Ability to sort outside of heirarchy and then return to heirarchy


I have just built a Smartsheet with parent, children heirarchy. I would really like to be able to sort the data based on a column within the rows. The resulting sort of a (any) column wants to ignore the heirarchy, however, I do need to be able to return to the heirarchy.


For example;

First screenshot is data entry.

Second screenshot Column 2 has been sorted, however, the result I need is for ALL of the numbers in Column 2 to be sorted in ascending order regardless of which parent the child belonged to.

And then, the CAVEAT is to be able to return the data back to the orginal heirarchy.


Any thoughts, ideas, tricks?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!