Troubleshooting: Latitude/Longitude Mismatch

The most common technical error when using raw coordinates (GPS data) is a "Mismatched Coordinate" error. This usually results in pins appearing in the middle of an ocean, or in an entirely different continent (frequently off the coast of Africa at 0,0). While this can be frustrating, it is almost always caused by a simple formatting or sign error in the Smartsheet columns.

Common Symptom: The "Null Island" Problem

If your pins are appearing at coordinates 0,0 (known by GIS experts as "Null Island"), it means GeoMap is receiving empty or invalid data for those rows.
- **Check for Empty Cells:** Ensure your Latitude and Longitude columns are fully populated.
- **Coordinate Swapping:** The most frequent error is swapping Latitude (Y-axis) with Longitude (X-axis). Remember: Latitude values range from -90 to 90 (North/South), while Longitude ranges from -180 to 180 (East/West). If your pins land in the Indian Ocean instead of North America, try swapping your column mapping in the GeoMap configuration.

Handling Signs and Decimal Degress

1. **The Minus Sign Matters:** For locations in the Western Hemisphere (The Americas) or Southern Hemisphere, a minus sign is mandatory. If you enter "74.00" instead of "-74.00" for a New York longitude, your pin will end up in Asia.
2. **Decimal Degrees vs. DMS:** GeoMap requires "Decimal Degrees" (e.g., 40.7128). It does not support degrees/minutes/seconds (40° 42' 46" N) directly. You can use a simple Smartsheet formula to convert these values before mapping the column to GeoMap.
3. **Hidden Characters:** Sometimes, data copied from a PDF or a website includes hidden non-breaking spaces or special characters. Use Smartsheet's `TRIM()` or `CLEAN()` functions on your coordinate columns to ensure the mapping engine receives pure numbers.

Expert Tip: Visual Data Validation

To prevent these errors from reaching your team, we recommend adding a "Validation Column" in Smartsheet. This column can use a formula to check if the Latitude is between -90 and 90 and Longitude is between -180 and 180. If the values are out of range, set the cell to "Error." You can then use GeoMap's filtering to hide any records with a "Coordinate Error," ensuring your live map remains clean and professional for your viewers while you correct the underlying data.