Is there a way to sort addresses into an opti...

Is there a way to sort addresses into an optimal route?

0 2 304
2 REPLIES 2

tony1
New Member

@DJ_Porter Not in AppSheet. You may be able to figure out some way to do this using Google Apps Scripts.

@DJ_Porter itโ€™s only doable with Google Apps Script. However a rough workaround might be using the DISTANCE({LatLong},{LatLong}) function provided you know the Lat/Long values and then sort as per distance. But for sure the distance value will be a bird-fly distance value.

Top Labels in this Space