Is there a way to sort addresses into an optimal route?
@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.
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |