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 help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!