Help with Distance between HERE() and Latlong < X

AppSheet AppSheet Q&A
1

Hello,
Can someone help with this? I am trying to have the distance between HERE() and a known LatLong be a qualified Valid_If if the distance is less than 1/2 mile.

I tried DISTANCE(HERE()-[Lat Long Column])<0.5

But that’s not working

Thanks in advance!

2

I believe the correct syntax is

DISTANCE(HERE(), [LatLong])<0.5

Just in case you are applying the valid_if to a DECIMAL type column that already has a distance expression in app formula , then I believe your valid_if could be a simpler [_THIS] <0.5

Edit: Minor correction in column type description, from DISTANCE to DECIMAL

3 Likes
3

DISTANCE returns a number in Kilometers I believe.

2 Likes
4

Yes,I also believe so. If @Joe_Seiler wishes to capture the distance in miles for half a mile, then correct expression probably would be

DISTANCE(HERE(), [LatLong])< 0.805

3 Likes
5

Good catch, I was just about to ask that.

Thanks to both of you, working perfectly

2 Likes