Dear all, I like to create a new sheet from the main sheet that shows only few of the locations. Grateful if you could let me know how I can limit the data from load script for a particular location.
So I like to duplicate the sheet into my own area and create one for only my sites that I am covering. As in the current status you need to filter and then add a bookmark etc. It is also not convenient to filter the sites and then out these sites you like to go into a particular location but then you lost the previous selection. And when sending to other parties they should only be able to see the sites relevant.
I believe this should be possible by editing the Data Aggregation may be?
I guess, You can try with sheet level triggers by adding the actions to select the region of your interest(On Activate the sheet) . And add one more sheet level trigger (on Leaving the sheet) for clearing all selections.