Help with DISTANCE Needed

[Ryan_Wagner]

Hi everyone. I’ve been having a blast with AppSheet and discovering how much can be done with it.

Currently, I’m trying to create a slice of a table where the only pins that will show up on the map are those within a half-mile radius of another column if it is populated.

In other words, I’m trying to pull all the lat,long(s) that are within a half-mile of the items in another column if the row is “not blank.” I have lat,long for these items, and I can get the formula to return with no errors, but it is not working.

Here’s what I have now:

DISTANCE([OBJECTID],[Lat,Long])<0.805,CONTAINS([OS_ASSET_ID], “Gravid Trap”)

The OBJECTID column has all the items I’m trying to narrow down to less than a half-mile. The OS_ASSET_ID column has the pins that I’m using as the center of the radius.

Did I explain that adequately?

Can anyone lend me a hand?

Thanks!