How to obtain Geocode from Address? What's this button do :)

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:

Screenshot 2022-08-03 10.48.52.png

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 ๐Ÿค”

2 5 885
5 REPLIES 5