Most of you will be aware of how to swap sheets with parameters so I am not going to dive into this.
One thing that you may have stumbled upon, however, is when you are trying to swap a sheet that is text only or a chart like a pie that does not have a dimension on rows or columns. In this case, the sheet will not entirely collapse and take about 30px of the container making things look odd.
Simple solution: just add a fake dimension on rows like a 1 or even a simple ”, define as dimension and your sheet will collapse.
Hope this might be useful and as always, appreciate your feedback.
Until next time.
Steffen