REMOVING ALL HIERARCHY FROM SHEET

Zac Baker · 10/01/18

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?

J. Craig Williams · 10/01/18

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

Zac Baker · 10/02/18

Thank you Sir. Much appreciated

REMOVING ALL HIERARCHY FROM SHEET

Comments

Categories