# Distance shown in google sheet
**URL:** https://community.glideapps.com/t/distance-shown-in-google-sheet/18186
**Category:** Ask for Help
**Created:** [November 10, 2020, 2:31am UTC](https://community.glideapps.com/t/distance-shown-in-google-sheet/18186 "2020-11-10T02:31:04Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@kingzy](https://community.glideapps.com/u/kingzy)
#### Post date: [November 10, 2020, 2:31am UTC](https://community.glideapps.com/t/distance-shown-in-google-sheet/18186/1 "2020-11-10T02:31:04Z")
hi, i’ve tried the distance function but would like to know to display in the sheet for calculations.
Tx.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [November 10, 2020, 4:03am UTC](https://community.glideapps.com/t/distance-shown-in-google-sheet/18186/2 "2020-11-10T04:03:11Z")
Your question isn’t very clear, can you provide a bit more detail on what you are trying to do?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 10, 2020, 4:22am UTC](https://community.glideapps.com/t/distance-shown-in-google-sheet/18186/3 "2020-11-10T04:22:45Z")
Distance column inside Glide won’t be written to the Sheets.
You must use a custom function via a script to do that, and it has its own limitation (not working with arrayformulas and limited calls per day).
What calculation do you want with the distance that can’t be done in Glide?
---
### Author:  [@kingzy](https://community.glideapps.com/u/kingzy)
#### Post date: [November 10, 2020, 5:44am UTC](https://community.glideapps.com/t/distance-shown-in-google-sheet/18186/4 "2020-11-10T05:44:51Z")
Thanks. @ThinhDinh
I just want to have the distance that’s calculated from the Glide data table, to be in the Google Sheet for calculation purposes. I understand now.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 10, 2020, 9:06am UTC](https://community.glideapps.com/t/distance-shown-in-google-sheet/18186/5 "2020-11-10T09:06:34Z")
Yeah, do you want us to help with doing those calculations inside Glide?
---
### Author:  [@kingzy](https://community.glideapps.com/u/kingzy)
#### Post date: [November 10, 2020, 9:22am UTC](https://community.glideapps.com/t/distance-shown-in-google-sheet/18186/6 "2020-11-10T09:22:24Z")
Well, right now I have a problem where the addresses entered, isn’t accurate at all.
I noticed Mapbox conversion to addresses aren’t accurate.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 10, 2020, 9:27am UTC](https://community.glideapps.com/t/distance-shown-in-google-sheet/18186/7 "2020-11-10T09:27:20Z")
You should use coordinates for best accuracy.
---
### Author:  [@kingzy](https://community.glideapps.com/u/kingzy)
#### Post date: [November 10, 2020, 9:49am UTC](https://community.glideapps.com/t/distance-shown-in-google-sheet/18186/8 "2020-11-10T09:49:11Z")
We’ll I’m planning to make a delivery app so I can’t use coordinates all the time.