Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Can I perform proximity searches based on a contact's ZIP Code?
I'm trying to conduct a query that will return all of the contacts within a geographic area based on their ZIP Code? For instance, if we have an event in Chicago and wanted to get a list of everyone who lives within 60 miles of the 60602 ZIP Code.
Our previous database application had this functionality, so I know that it's possible, but would be curious to see if it's possible with Smartsheets.
Thanks!
Comments
-
I would say no. There might be a third-party solution that allows you to do something like this, but Smartsheets does not inheritantly have any functions related to addresses or phone numbers. You can find their complete function list here: https://help.smartsheet.com/functions
-
I was looking through the Apps and Integration and Smartsheets has a lab that will allow you to plot all your addresses on a map. This might help you to visually gather the users near you.
For more information see: https://www.smartsheet.com/apps/smartsheet-maps
It might be a good starting point.
-
Appsheet.com (one of our integration partners) can do lat/long but not zipcodes (yet)
Best,
Kara
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives