Ability to sort outside of heirarchy and then return to heirarchy

PeggyLang
PeggyLang ✭✭✭✭✭✭

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?


image.png


image.png


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!