Track motion and geofencing with new Location formulas

GeoSheet now has seven new formulas for analyzing location data over time. Drop a LOCATION cell that tracks a user's GPS, and these formulas let you derive motion, geofencing, and history insights directly in your spreadsheet.

Motion analytics

• SPEED(cell, [units]) — current speed of a tracked user, based on the two most recent position updates. Units: kph (default), mph, ms, knots.
• HEADING(cell) — forward compass heading in degrees from true north, computed from the last two positions. Returns #N/A when stationary.
• TRAVELED(cell, since, [until], [units]) — total distance covered during a time window.
• LOCATIONAT(cell, datetime) — the POINT value that was active at a specific moment in history.

Geofencing

• GEOFENCE(point, polygon) — returns TRUE if a point is inside a polygon. Works with literal POINTs or cell references.
• GEOFENCEIN(cell, polygon, [since]) — the ISO datetime of the most recent time a tracked user entered the polygon.
• DWELLTIME(cell, polygon, [since]) — total time spent inside the polygon, returned as a DURATION value.

All seven formulas integrate with Time Warp, so they update automatically as new location data arrives. Use them together — for example, DWELLTIME(A1, site_polygon, TODAY()) tells you how long someone has been on-site today, while SPEED(A1, "mph") shows their current speed as of the most recent ping.

These are the first of many location analytics functions coming in the next few releases.