Following @Saddles' suggestion I ended up adding:
function SHEET() { return SpreadsheetApp.getActiveSheet().getIndex(); }
to my sheet's Apps Script library and that seems to have worked.