How to extract the latitude and longitude from GPS coordinates workflow

In workflow, what would be the formula if I just need the use latitude part of the GPS or longitude?

Thank you,

INDEX(
    SPLIT([GPSCoords], ",")
,1)

SPLIT() takes a value and turns it into a list, delimited by the value provided, in this case, the comma in the coordinates.

INDEX() takes in a list and a number to return the specific item at that number, if anything exists. In your case value 1 will be the latitude, and value 2 will be the longitude. Values other than those two will return with nothing in this instance.


1 Like

Thank you for your help, it worked

1 Like

@Erez_Michaeli
Below expression will give you the Latitude of your location coordinate

LAT([LocationColumn])


1 Like