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
-
A row report! NEVER even thought of this!!!
I think this works perfectly.
Answers
-
A row report! NEVER even thought of this!!!
I think this works perfectly.
-
Aha! A Row Report is a great idea. π I'm glad that worked for you!
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Help Article Resources
Categories
Check out the Formula Handbook template!