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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!