Has anyone found a way to validate their address fields in Smartsheet? We are currently using a Smartsheet form to collect business license data and would like to integrate our data to ArcGIS to map the business locations.
Currently, we are manually updating all of the citizen-submitted addresses which is a huge time suck. Is there a way to connect to our geo-locator or some other authoritative address list we own to automate address validation?
The more we can do to clean up the addresses before the form is submitted, the better. Simple instructions in the form to tell citizens how to fill out the fields without automated intervention is not a sustainable solution for us. Thanks!