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

(DJ Porter) #1

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

(Tony Fader) #2

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

(Levent KULAÇOĞLU) #3

@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.