# Any ways to create a distance in google sheet using array formula ???

**URL:** <https://community.glideapps.com/t/any-ways-to-create-a-distance-in-google-sheet-using-array-formula/37154>\
**Category:** Ask for Help\
**Created:** [January 14, 2022, 7:04am UTC](https://community.glideapps.com/t/any-ways-to-create-a-distance-in-google-sheet-using-array-formula/37154 "2022-01-14T07:04:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chloe\_Lim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chloe_lim/32/37375_2.png) [@Chloe\_Lim](https://community.glideapps.com/u/Chloe_Lim)\
**Post date:** [January 14, 2022, 7:04am UTC](https://community.glideapps.com/t/any-ways-to-create-a-distance-in-google-sheet-using-array-formula/37154/1 "2022-01-14T07:04:12Z")

</div>

I used this formula in google sheet,  
=GOOGLEMAPS(B2,C2,“kilometers”)  
it works， but how can I make this algorithm into an array formula？  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/2/02b50a6271b65773a29e0c730bb166eb1dd1665f.png)

I also tried another way like  
=GOOGLEMAPS(B:B,C:C,“kilometers”)  
but it only shows the first result to the other rows below

---

<div class="post-metadata">

**Author:** ![Jesus\_Or](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jesus_or/32/27555_2.png) [@Jesus\_Or](https://community.glideapps.com/u/Jesus_Or)\
**Post date:** [January 14, 2022, 7:12am UTC](https://community.glideapps.com/t/any-ways-to-create-a-distance-in-google-sheet-using-array-formula/37154/2 "2022-01-14T07:12:12Z")

</div>

En la tablas de glide hay una función para determinar la distancia la has probado? Tal vez te funcione y en las tablas los cálculos son más rápidos

---

<div class="post-metadata">

**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\
**Post date:** [January 14, 2022, 7:52am UTC](https://community.glideapps.com/t/any-ways-to-create-a-distance-in-google-sheet-using-array-formula/37154/3 "2022-01-14T07:52:49Z")

</div>

You can directly use the distance column in glide or you can hardcode the formula in all cells below  
With if condition