Darrell_Miller - profile

Darrell_Miller · May 21, 2022

I have three columns in my table. Lat/Long Combined - Example: 18.194608875237545, -63.08524490907154 Latitude - Example: 18.194608875237545 Longitude - Example: -63.08524490907154 The formula I’m using in the {Latitude} column is: IF( FIND(",", {Lat...

Darrell_Miller · May 24, 2022

momentsgoneby80: IF( FIND(",", {Lat/Long Combined}), LEFT( RIGHT({Lat/Long Combined}, LEN({Lat/Long Combined}) - LEN({Latitude}) - 2 ), FIND( ",", RIGHT({Lat/Long Combined}, LEN({Lat/Long Combined}) - LEN({Latitude}) - 2 ...

User Statistics

User Activity

Remove #ERROR! when field is empty

Re: Remove #ERROR! when field is empty