Skip to content
Advertisement

I want to apply script to multiple subsheet in one Sheet

I followed youtube instruction and copied this script

JavaScript

I want to apply this script to all subsheet in the file.

so I tried to add more sheet name like

JavaScript

or

JavaScript

and they didn’ work.

I don’t have any, even rudimentary knowledge to this area, could you teach me how can I apply this script on whole subsheet, please?

Advertisement

Answer

I have changed your code slightly according to the task at hand:

JavaScript

I don’t think it’s a good idea to run getDatetimeCol() every time you make a change in the table – it’s better to do it only when the changes occur in the right sheets and cells

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement