I have a Google spreadsheet with multiple sheets : one for input and others for formulas. These other sheets are hidden and the formulas not meant to be edited/seen.
The goal is to have many people making copies and providing various inputs, while the hidden sheets remain hidden.
If I make them editors, they can make a copy but have free access over it after. I also tried using the ImportRange function, but it only works when using the original spreadsheet and not with copies.
Is there any way, maybe via a script or whatever else, to prevent the access to the hidden sheets while allowing the math to be done from the first sheet inputs?