Getting the miles between two points - LatLong and an address?

I have two columns:

LatLong (from Table1)
Address (from Table 2)

How can i get the miles between them?

There is a DISTANCE() function but it requires 2 LatLong types. Right now, AppSheet does not have a way for you to get the LatLong value for a street address.

Other developers are reporting that they have created a webhook to the Google API in order to get the LatLong value for an address. This is free IF you stay under the monthly limits.

1 Like

Thank you…