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ß
Δημιουργήθηκε την
22/10/2018
Ενημερώθηκε την
13/04/2020
Άδεια
Μη διαθέσιμη
Εφαρμόζεται σε

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