What's inside
=TERRITORY()=VISIT_ORDER()=LOGBOOK_LINK()=VISIT_STATUS()=INSTAMAP()- →Put your driver names in B1 and C1 (add more columns for more vans) — =TERRITORY() assigns every stop a fair, geographically tight patch per driver.
- →Each crew link in row 2 is pre-signed with that driver's name and scoped to their stops — text each driver theirs.
- →Sort by the Van then Order columns to read the board as run sheets.
- →The Status → Photo columns fill in live as drivers tap stops done.
Set-up (60 seconds)
- Click "Make a copy" above — the template opens in your Google Sheets.
- Install the free InstaMaps add-on (100 lookups/day free; 1,000/day with a free email unlock).
- Turn the formulas on: in your sheet, open Extensions → InstaMaps → ⚡ Enable formulas (once per sheet). Any
#NAME?cells recalculate — reload the page if they linger. - Replace the sample rows with your data — every formula stays live.
Questions
=TERRITORY() clusters the stops geographically and balances the count per driver (within ~15%), so nobody gets the "12 miles one way, 25 the other" day. Add a value column to balance by load size instead of stop count.
Yes — the crew links use FILTER() to scope each link to that driver's van, and the link is signed with their name, so every check-off is attributed automatically.
Dispatch tools charge per driver (Circuit ~$100+/mo, OptimoRoute per-driver seats). Here drivers are links, not seats — a WhatsApp message is onboarding.
The board, the splits, crew links, photo proof and the live map are free, and normal daily use fits the formulas' free tier. Advanced team features — live sync writing every tap into your sheet in under a second, and instant visit-alert emails — are part of InstaMaps Pro today, and more paid team features may come later; this workflow stays free.