I am looking to be able to sort addresses in a list based on distance.
I have looked at this article:
https://support.google.com/appsheet/answer/10106705?hl=en
And I have a virtual column, [_computedAddress], that returns a concatenation of the fields that will make up a full address.
This dialog shows Geocoding Enabled as being checked:
But i cannot seem to figure out how to access the geocoded LATLONG values in order to use the computed address in a DISTANCE() expression ๐ค
User | Count |
---|---|
17 | |
14 | |
8 | |
7 | |
4 |