Reverse Geocoding
I am using a form with the pin drop to track sales employees in person visits / cold calls. The return value in my data sheet is the location coordinates hyperlink that takes you to Google Maps. Is there a way I can extract the address information from the coordinates into a separate column on my sheet? I have an enterprise account and have read what I can find on bridge and API but nothing really telling me how to do this. TIA!
Answers
-
Hi CFT!
In a new column, just do a simple "={Column Name}@row" and make it a column formula.
This will convert the hyperlink to text. This this all you're looking to do or are you trying to get the URL separate?
Joe Goetschel | Smartsheet Director | SCS CLOUD - Smartsheet Partner
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
-
I have it separated, looking to take the newly formatted Lat / Long and have it automatically convert and add address info into my sheet in separate columns, City, State, County. I could live with a full address and pull the data via formula if I had to.
-
Totally understand now. Yes, you can do this with a Bridge workflow via JavaScript.
Let me know how we can help!
Joe Goetschel | Smartsheet Director | SCS CLOUD - Smartsheet Partner
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
-
Thanks Joe, I am looking for instructions on how to do this. I am far from a programmer. I was hoping to get something detailed so I can get it set up.
My sheet set up is:
My hope is for City / State / County to autofill.
-
@CFT Shoot me an email if you don't mind and I can get you some info! joe.goetschel@scscloud.com
Hope to talk soon,
Joe Goetschel | Smartsheet Director | SCS CLOUD - Smartsheet Partner
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
