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 |
---|---|
59 | |
25 | |
13 | |
12 | |
6 |