REF_ROWS()

[Ryan_F]

What expressions should I use to Return a list from the rows in a reference table, sorted by distance of [Location] in that reference table to a HERE() position?  More specifically said, I want my user to call a list from another table and sort it based on its distance from my current location.  I cannot compare against this row's key column.   

Thanks

[Suvrutt_Gurjar]

If understanding of your requirement is correct, please take a look at the following sample app

https://www.appsheet.com/templates/Initialize-a-form-with-values-from-nearest-location?appGuidString...

The app initializes the nearest person in the Forms table's "Person" column. You could instead use an expression of ORDERBY(Person[ID],[Distance in km], FALSE) in the valid_if of [Person] column in Forms table to sort the persons in the order of distance starting with the nearest.

In your case the [Person] needs to be replaced by [Location]

https://help.appsheet.com/en/articles/2357312-orderby