Address

SMFORCE utilizes Google to assist our users with addresses and locations.  In doing to our system utilizes a FULL address in lieu of separate fields for Address, City, State, and zip.

When importing companies or contacts you need to format your address into the FULL address format if it is not already.

The FULL address format is as follows

"address, city, state, zip" --- all in one line.

We also allow the ability to type a PLACE in the search bar in lieu of an address.  

For example, if you type "Wrigley Field" and press search our system will automatically find the correct address for Wrigley Field.  This also works with businesses.

Pro Tip! 

Here is a useful Formula in Microsoft Excel to help combine a broken out address field into a single FULL address field.

=CONCAT(Address cell," , ",City Cell," , ",State Cell," , ",Zip Cell)

Some other useful formulas to ensure the data is formatted properly before uploading include

=PROPER("cell with text")

Proper will change the text string to proper case.