Can I use appsheet to automatically calculate mileage based on two address locations? if so, any guidance?
Unfortunately only with LatLong values.
i have those too
i have a sheet with columns: Location Name, Addess, Latitude, Longitude
I also have a form for Date, Start Location, End Location, and hopefully an autocalculated milage between the two.
Right now, the start and end named are selected by enum. I’m not sure how to connect all of it for a route/mileage calculation…
Justin, we have a function to compute distance between two points (as the crow flies). But you need road distance. For that, you’re going to need to use an external service (like Google Maps API). You might have to figure out how to integrate that into a spreadsheet formula. Eg: http://www.gadgetsappshacks.com/2014/02/calculating-distance-between-two.html
Got it. Worked perfect! Thanks for your help