Calculating KM Distance between Lat and Long

Amanda Carta
Amanda Carta ✭✭✭✭
in Formulas and Functions

Good morning. I have tried the 2 formula's that I found on the internet and copilot and neither are working for me. Can someone please help me figure out how to calculate the KM distance between the lat longs?

Lat_Long_Help1.png Lat_Long_Help2.png
· Share on FacebookShare on Twitter

Best Answer

  • Soumitra Bhowmick
    Soumitra Bhowmick ✭✭✭✭✭
    Answer βœ“

    Seems like Smartsheet doesn't have inbuilt formula or Map support for these type of calculation. You might have to take help of Thirdparty applications.

    Regards,

    Soum

    Please accept my answer as Solution if it helped you

    · Share on FacebookShare on Twitter

Answers

  • Soumitra Bhowmick
    Soumitra Bhowmick ✭✭✭✭✭
    Answer βœ“

    Seems like Smartsheet doesn't have inbuilt formula or Map support for these type of calculation. You might have to take help of Thirdparty applications.

    Regards,

    Soum

    Please accept my answer as Solution if it helped you

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!