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 |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |