Automate open subsitem

[Miratr]

Hi,

Is there any way to automatically open the subitems?

[Pablo_DV]

No, there isn’t. It was already discussed recently.

Is there a way to create a button that visually expands all rows with subitems?

By “expand,” I mean what happens when you click the small triangle next to a row that has subitems, revealing all the nested rows underneath. I’m not referring to the “Expand row” function that opens the row in a detailed view. Basically, I’d like to know if there’s any way to trigger that visual expand (or collapse) action for all rows at once — ideally with a button or a formula. Thanks!