Set Column values

Tu es un génie Alexis :star_struck:

1 Like

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)) tu peux même mettre la formule dans ta ligne de titre :wink:

1 Like

Just to add to what Jeff said, it’s actually a lot easier than you might think. The 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.
3 Likes

Thanks a lot Darren for these very cleay step by step explanations :slight_smile: