🌱 Google Maps

lat/long to zip

http://maps.googleapis.com/maps/api/geocode/json?latlng=38.25731,-85.7609&sensor=true

Code

Auto center

function autoCenter(map, markers) {
  // centers maps based on markers

  // Create a new viewpoint bound
  var bounds = new google.maps.LatLngBounds()

  // extend to each marker
  for (var i = markers.length - 1; i >= 0; i--) {
    bounds.extend(markers[i].position)
  }

  // Fit these bounds to the map
  map.fitBounds(bounds)
}

Add leading zero to current month if necessary

  • 1 => 01
  • 2 => 02
  • 10 => 10
=IF(LEN(MONTH(TODAY()))=1;CONCATENATE(0,MONTH(TODAY()));MONTH(TODAY()))

http://webapps.stackexchange.com/questions/35526/leading-zeros-in-google-spreadsheet-automatically-removed

=iferror(if(match($D401,'prod-compiled'!$B:$B,0)>0, INDIRECT("prod-compiled!$A"&(match($D401,'prod-compiled'!$B:$B,0))), ""))
=Arrayformula(master!A2:A)

http://codingisforlosers.com/google-sheets-query-function/

Made by Brandon . If you find this project useful you can donate.