Ability to sort outside of heirarchy and then return to heirarchy

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?

PeggyLang

A row report! NEVER even thought of this!!!

I think this works perfectly.

PeggyLang

A row report! NEVER even thought of this!!!

I think this works perfectly.

Genevieve P.

Aha! A Row Report is a great idea. 🙂 I'm glad that worked for you!