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."
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives