REMOVING ALL HIERARCHY FROM SHEET
I'm using a sheet (Grid view) that I initially needed Parent and child rows on, but we have decided we would like a simpler format. I don't want to delete my sheet and start over because I need all the current data as I am still using it. BUT I want to go back thru the sheet and re-format it without the parent/child hierarchy + and - every time I click to indent or outdent (attempting to get rid of them) they just move to the next line on the sheet. Is there a way to completely remove it all without them just moving around?
Comments
-
This is the quickest way I have found to do it (baring the API)
1. Create a column (Text/Number) and add this formula to every cell
=COUNT(ANCESTORS([Task Name]@row))
[Task Name] should be your Primary column name.
2. Filter on the highest number you find or use 'is one of' and select the highest number.
For every contiguous range, you can select them and use Ctrl+M (outdent) to outdent them. If you have a few large blocks of indented rows, this will go easier, but even for small chunks, I find it easier.
That is if row 22-25 are shown in the filter, you can select them all at once.
Do this for all the rows at this 'level'.
3. Repeat for the next number (if your hierarchy is 4 levels, you'll need to do this 3 times)
A pain, but (for me) quicker than one at a time.
Craig
-
Thank you Sir. Much appreciated
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives