Make Collapse ALL default

Joe Fulmer

I have clients with indented children. Everytime I come to the sheet the children are fully expanded. How do I make Collapse ALL the default setting? Matters not if I save it as collapsed.

Richard Rymill SBP

Hi Joe

something strange happening at your end then, because when I open a sheet it opens where the hierarchy was last open, ie Fully opn or partial or closed?

Is someone else opening up your hierarchy?

Hope that helps?

Richardr

Joe Fulmer

Where would you set heirarchy other that with collapse?

Joe Fulmer

What's interesting is this behavior just started. It seems its coincident with using the new Filters tool.

If I collapse the sheet then move to another sheet, then back to the collapsed sheet....it's no longer collapsed, even if I save before leaving.

John Randazzo

Yes, it seems to have started with release of the new Filtering functions.

I'm having the same issue ; In my case, after removing a filter, all rows are expanded. This is most undesirable. Is there a keystroke or hotkey to collapse all ?

Benjamin Walker

The collapsed/expanded view is shared between all users on the sheet. if your client expands the rows and saves that is the view you will see when you open the sheet.

Using Find (cntrl+F) and/or applying filters will expand rows as well but will not always be as apparent.

Joe Fulmer

You have to click the column header for the dropdown then select collapse all. Don't want to do this each time I access the sheet

John Randazzo

Thanks much Joe - works great..

An option for setting a default would be simpler ...

Shaine Greenwood

@JoeThe default behavior is that the hierarchical expand/collapse reflects the most recent save made to the sheet—whether that's your save or another collaborator's save.

If this appears to only happen on one sheet for you, ask all of your collaborators to close the sheet temporarily on their end. Then make hierarchy changes and save. Close the sheet then navigate back to the sheet and see what it looks like.

Your sheet should reflect the way you set the hierarchy after you've saved, if it still doesn't and you've confirmed no other collaborators are looking at the sheet (and possibly overridding your saves), then email[email protected]so our team can troubleshoot further.

Joe Fulmer

Thanks....I will try this.

The issue is we use the parent / child feature a lot....and I'm sure with autosave the expanded list gets inadvertantly saved due to autosave.

Xavier LN

Hi, I had the same problem and narrowed down the issue:

- If there is no filter selected, collapsing is kept when we come back to the sheet

- but if there is a filter activated, then all lines are uncollapsed when we come back to the sheet

--- I tried to save the sheet manually after collapsing to make sure this was not a side effect of auto-save

--- and I'm the only one using the sheet so this can't be due to other users

This clearly looks like a bug, which makes the collapsing feature useless as soon as we have a filter. If confirmed, any chance that could this be corrected?

Thank you,

Joe Fulmer

It is an acknowledged bug that's taking a long time to get corrected. The new filter option is great, but this makes it very unfriendly when using indented child records.

Xavier LN

OK thanks for the feeddback/confirmation.

Do you have any visibility about when it will be corrected? (So we now if we should reorganise sheets or if we can wait)

Thanks you,

Xavier

Joe Fulmer

不…有人告诉我几个月前在磨破ks.

Susan Alexander

Any word on this? My issue is the same as Xavier LN. I'm using a filter (only show tasks that are not completed) and every time I leave a sheet and return to it, it's completely expanded, even if I saved it before leaving. Very annoying, since I move between sheets continually.

Thank you!

L Thrasher

I agree. I'd like to have my sheet default to 'collapsed' after I filter.