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?