Posted 12 November 2020, 2:28 am ESTGood morning/afternoon
I'm currently trying to clean up a workbook from the existing sheets. It seems the only method available from the documentation is: removeSheet(sheetIndex)
The removeSheet, however, does keep the indexes of the previous sheets so once the event triggers a new default sheet gets generated with a progressive number (looking at the sandbox below you will see Sheet4 after clicking the button at the bottom of the workBook).
Checkout my sandbox:
The above seems like the workBook keeps previous things cached so I'm wondering what's the best practice and what could I use to have a less hacky solution.