3 ms·
Do they all need to be editing the same sheet? At work when we ran into loading issues we separated it out region wise and provided links to each sheet on a web
by op03 7y ago
Do they all need to be editing the same sheet? At work when we ran into loading issues we separated it out region wise and provided links to each sheet on a webpage.
- punnerud 7y agoThat could work. There is the drawback that on the biggest logical separation (like state in US) these are large boarders compared to area, so a lot of them would be overlapping in how people could work together across the regions
- op03 7y agoWe did it sort of organically...started with just a North, South division which reduced loading issues...and then those pages slowly grew and branched into different zones. Most people only needed data from their zone. It depend I guess on what your users are looking for. The few who needed data from all pages created and shared their own sheets with aggregation/tracking etc from all sheets.