☰

Munzee Garden Pin Checker

Verify Munzee Garden Pins!

Skapare
Technical-13
Dagliga installationer
0
Totala installationer
139
Betyg
0 0 0
Version
2020.04.13.1012ß
Skapad
2018-10-22
Uppdaterad
2020-04-13
Licens
N/A
Gäller för

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