I have the same question. I love that you can have charts appear and disappear based on actions but I can not get it to size appropriately.
1 of 1 people found this helpful
Fix the height or width of the 'main' sheet (or container of sheets) to whatever pixel size you want. Then on the collapsing sheet set the fit to entire view (and make sure the width or height is NOT checked (pinned). Put both into a master container. When fit entire sheet collapses the main sheet will move up or down.
Here's a great way to control the opening and closing of the sheet:
That seems so obvious when I look at it again after 2 years