Greetings all.
I started to do a project on APP Script but I don't know much javascript.
The goal is this:
I have a list of google sheets and I want to have a master file from where I can run the Script and pull data from all sheets.
When I run the script I want it to clear the master sheet content and then from each sheet I should take each row and check if the data in Column A is a date higher than 8/1/2022 (MM/DD/YYYY)
which would be the quickest way to solve this while having in mind performance. All these sheets have thousands of rows inside.
I tried it up to some point but I am messing up the condition so I am either getting all the data from all the sheets, including empty rows or I am getting nothing at all.
I think that the code I've written so far ca be shortened and optimized.
All help is appreciated.
LinkedIn
Twitter
