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.
Thank youโฆ
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |