Straight-line distance between two coordinates (m) with the DISTANCE() function

Purpose: display the straight-line distance (not a road itinerary) in meters between two points.

Ideal for routing, logistics, field operations, or allowance calculations.

Prerequisites

• Two Coordinate columns (e.g., Coordinate A, Coordinate B). You can pick points on the map (long press to move). 
• One Formule column (e.g : Distance ()).

Steps:

1. Add a column → Formule → name it Distance (). 
2. Enter the formula:

DISTANCE() returns a value in meters (as-the-crow-flies).

3. Column options: 

• Output: Number 
• Decimals: 0 
• Symbol: m

4. Validate: the cell displays the distance in meters between the two coordinates.

Kilometer option

DISTANCE() returns a value in km (as-the-crow-flies).

Column options: 

• Output: Number
• Decimals: 0