I am trying to run a Google Sheets App Script whenever a checkbox is ticked.
- Other users should be allowed to tick the checkbox.
When ticked, an App Script shows/hides different parts of the sheet.
- This works fine for the owner of the sheet, but not for other users.
I would like to achieve the following workflow:
- User makes a copy of the entire Google Sheet
- User shares copy with colleagues
- App Script fires for user and colleagues
Things I have tried:
- Using an onEdit Simple Trigger fails for other users due to “You are trying to edit a protected cell or object.”
- Setting up an Installable Trigger allows other users to run the App Script.
- However, manually setting up a trigger each time the sheet is copied can not reasonably be expected from users.
How would I want to trigger the App Script on a copied sheet?