# Set Column values

**URL:** <https://community.glideapps.com/t/set-column-values/30985>\
**Category:** Ask for Help\
**Created:** [August 26, 2021, 5:18pm UTC](https://community.glideapps.com/t/set-column-values/30985 "2021-08-26T17:18:41Z")\
**Posts on this page:** 4\
**Page:** 2

<div class="post-metadata">

**Author:** ![Lionel\_Janus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lionel_janus/32/29477_2.png) [@Lionel\_Janus](https://community.glideapps.com/u/Lionel_Janus)\
**Post date:** [August 26, 2021, 9:10pm UTC](https://community.glideapps.com/t/set-column-values/30985/22 "2021-08-26T21:10:12Z")

</div>

Tu es un génie Alexis 🤩

---

<div class="post-metadata">

**Author:** ![Alexis\_AZOULAI](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexis_azoulai/32/20550_2.png) [@Alexis\_AZOULAI](https://community.glideapps.com/u/Alexis_AZOULAI)\
**Post date:** [August 26, 2021, 9:40pm UTC](https://community.glideapps.com/t/set-column-values/30985/23 "2021-08-26T21:40:49Z")

</div>

Et en suivant cet exemple ([https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/11?u=alexis\_azoulai)](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727/11)) tu peux même mettre la formule dans ta ligne de titre 😉

---

<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:** [August 27, 2021, 2:34am UTC](https://community.glideapps.com/t/set-column-values/30985/24 "2021-08-27T02:34:56Z")

</div>

> [@Lionel\_Janus](#):
>
> Thank you. Ok I am ready to do that but is it really easy to migrate everything or will I have to rebuild the entire app? I am a bit afraid because of the time I have spent already on the app !

Just to add to what Jeff said, it’s actually a lot easier than you might think. The [Find all uses](https://docs.glideapps.com/all/reference/data-editor/managing-columns#find-all-uses) feature is your best friend when doing something like this.

Let’s say that you have a GS column called “Col1” that does a simple calculation, and you decide to replace it with a Glide math column. All you need to do is:

- Create your new math column
- Then locate “Col1” in the Data Editor and go to “Find all uses”
- A list will appear on the right hand side in the data editor, and you can very quickly go through them one by one and change each to use your shiny new math column
- Once done, and “Find all uses” shows that your old GS column isn’t used anywhere anymore, you can head over to the GSheet and safely remove it.

---

<div class="post-metadata">

**Author:** ![Lionel\_Janus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lionel_janus/32/29477_2.png) [@Lionel\_Janus](https://community.glideapps.com/u/Lionel_Janus)\
**Post date:** [August 27, 2021, 8:10am UTC](https://community.glideapps.com/t/set-column-values/30985/25 "2021-08-27T08:10:30Z")

</div>

Thanks a lot Darren for these very cleay step by step explanations 🙂

[Previous page](https://community.glideapps.com/t/set-column-values/30985.md?page=1)