☰

Munzee Garden Pin Checker

Verify Munzee Garden Pins!

Maker
Technical-13
Dagelijks aantal installaties
0
Totaal aantal installaties
139
Beoordelingen
0 0 0
Versie
2020.04.13.1012ß
Gemaakt op
22-10-2018
Bijgewerkt op
13-04-2020
Licentie
N.v.t.
Wordt toegepast op

Quick and easy way to check if garden pins are the right type and in the right place!

Put this code in the top "Checker Link" cell (default: J2) of your sheet and drag copy to the last row. :)


=IF(AND($H2<>"",$I2<>""),HYPERLINK("https://www.munzee.com/m/"&$H2&"/"&$I2&"/map/?lat="&$D2&"&lon="&$E2&"&type="&$F2&"&name="&SUBSTITUTE($A2,"#","%23"),$H2&"/"&$I2),IF($H2<>"",IF(REGEXMATCH($H2,"50( ?['fF]([oO]{2})?[tT]?)?( ?[eE][rR]{2}[oO][rR])?"),HYPERLINK("https://www.munzee.com/map/?sandbox=1&lat="&$D2&"&lon="&$E2&"&name="&SUBSTITUTE($A2,"#","%23"),"SANDBOX"),HYPERLINK("https://www.munzee.com/m/"&$H2&"/",$H2)),""))