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