Greasy Fork is available in English.

Munzee Garden Pin Checker

Verify Munzee Garden Pins!

ئاپتورى
Technical-13
بۈگۈن قاچىلانغىنى
0
جەمئىي قاچىلانغىنى
139
باھا نومۇرى
0 0 0
نەشرى
2020.04.13.1012ß
قۇرۇلغان ۋاقتى
2018-10-22
يېڭىلانغان ۋاقتى
2020-04-13
ئىجازەتنامىسى
يوق
قوللايدىغىنى

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)),""))