formula to calculate distances between locations
A formula to calculate distances beween locations (city, state, zip code, country, latitude, longitude, etc). Also, the ability to plot locations and drive time between locations on maps would be great.
This is now available! Check out the comment.
We now have the ability to calculate distances between two coordinates (latitude and longitude. You can use the following function in a Triggered Number field:
The first two inputs to the distance() formula would be Location fields (latitude and longitude) in the table. The last input can be "mi" for miles or "km" for kilometers.