1 Reply Latest reply on Jun 28, 2018 8:24 PM by swaroop.gantela

    Match city parameter to lat/long then filter data to 50mile radius of lat/long

    Stephen Yang

      Hi been thinking about this for awhile and haven't been able to find a solution.

      Essentially a user picks a City Location from a drop down parameter.

       

      Then I would like the sheet to filter all records that are with a specific radius to that city.

       

      All city locations have a matching lat and long field associated with it and the range can be calculated in this manner.

       

      So how do i filter based on the matching lat long associated with a city parameter?

       

       

       

      Thanks in advance,