# Reorder Google Sheets columns when moved in Glide data editor

**URL:** <https://community.glideapps.com/t/reorder-google-sheets-columns-when-moved-in-glide-data-editor/43212>\
**Category:** Feature Requests\
**Created:** [June 17, 2022, 5:58pm UTC](https://community.glideapps.com/t/reorder-google-sheets-columns-when-moved-in-glide-data-editor/43212 "2022-06-17T17:58:45Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![justinjmp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/justinjmp/32/43205_2.png) [@justinjmp](https://community.glideapps.com/u/justinjmp)\
**Post date:** [June 17, 2022, 5:58pm UTC](https://community.glideapps.com/t/reorder-google-sheets-columns-when-moved-in-glide-data-editor/43212/1 "2022-06-17T17:58:45Z")

</div>

Is it technically possible to rearrange Google Sheets columns when they are moved in Glide Tables? When using this data store it would make for a cleaner experience if columns mirrored each other.

---

<div class="post-metadata">

**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\
**Post date:** [June 17, 2022, 7:31pm UTC](https://community.glideapps.com/t/reorder-google-sheets-columns-when-moved-in-glide-data-editor/43212/2 "2022-06-17T19:31:55Z")

</div>

I don’t think.its beneficial its better like this specially when integration is placed on a google sheet it might get messed up

---

<div class="post-metadata">

**Author:** ![justinjmp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/justinjmp/32/43205_2.png) [@justinjmp](https://community.glideapps.com/u/justinjmp)\
**Post date:** [June 17, 2022, 7:36pm UTC](https://community.glideapps.com/t/reorder-google-sheets-columns-when-moved-in-glide-data-editor/43212/3 "2022-06-17T19:36:34Z")

</div>

That’s a good point - rearranging would indeed result in potential changes to integrations or formulas.

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [June 18, 2022, 12:02am UTC](https://community.glideapps.com/t/reorder-google-sheets-columns-when-moved-in-glide-data-editor/43212/4 "2022-06-18T00:02:13Z")

</div>

I don’t think this would be a good idea, though I understand that when you are building a project in Glide, you would prefer your sheets in GS/Excel and tables in GT to be mirrors of each other.

In essence, Glide maps _data_ between GS and GT, but it doesn’t map or control the _layout_ of a sheet (column order, colors, fonts, filters, conditional filtering). This applies to bases in Airtable.

Why is that?

- Sheets in GS/Excel or bases in Airtable may have a life of their own: used by other team members outside of Glide. Your Glide project is meant to live _on top_ of this data, not take over and potentially affect the user experience within the sheet/base.
- Importantly, some formulas in GS/Excel are dependant on the order of columns. A good example of this would be vlookup. If Glide were to change the order of columns, vlookup formulas would potentially break. (An alternative to vlookup to avoid this would be to use index+match, but a lot of people are more comfortable with vlookups.)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 18, 2022, 2:38am UTC](https://community.glideapps.com/t/reorder-google-sheets-columns-when-moved-in-glide-data-editor/43212/5 "2022-06-18T02:38:29Z")

</div>

As we would say in Aus… “[yeah, nah…](https://www.lifehacker.com.au/2020/07/difference-between-yeah-nah-and-nah-yeah/)” 😉

---

<div class="post-metadata">

**Author:** ![justinjmp](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/justinjmp/32/43205_2.png) [@justinjmp](https://community.glideapps.com/u/justinjmp)\
**Post date:** [June 18, 2022, 3:48am UTC](https://community.glideapps.com/t/reorder-google-sheets-columns-when-moved-in-glide-data-editor/43212/6 "2022-06-18T03:48:33Z")

</div>

Yeah … nah 😂😂😂 you’ve all convinced me
