If it's a shared sheet, then either everyone using the sheet has to authorize the script (and this will be necessary if you're using macros or a script triggered from a button or a menu). If you're using something like an onEdit trigger, you can have one user authorize the script if you use an installed trigger (add it manually) versus using the onEdit function name to use the simple trigger functionality.
This video is just meant to describe and explain the script authorization process, not how to write apps script. I have other videos on apps script and there are many other apps script tutorials out there as well to help you learn apps script.
much appreciated. It's a wonder how such a simple task was made so complicated.
So glad this was helpful!
Will this work on a shared sheet?
If it's a shared sheet, then either everyone using the sheet has to authorize the script (and this will be necessary if you're using macros or a script triggered from a button or a menu).
If you're using something like an onEdit trigger, you can have one user authorize the script if you use an installed trigger (add it manually) versus using the onEdit function name to use the simple trigger functionality.
I think I could follow your video if I already knew the skill I'm trying to learn...
This video is just meant to describe and explain the script authorization process, not how to write apps script. I have other videos on apps script and there are many other apps script tutorials out there as well to help you learn apps script.