# Set Column values **URL:** \ **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:** 20\ **Page:** 1
**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, 5:18pm UTC](https://community.glideapps.com/t/set-column-values/30985/1 "2021-08-26T17:18:41Z")
## Bonjour à tous, Je cherche à mettre en place un bouton RESET que me permettrait de réattribuer des valeurs à certaines cellules. Est-il possible de rendre une cellule vierge (blank) ? Je parviens facilement à remettre à 0 mais le chiffre 0 me pose problème par rapport aux différentes formules du projet (Livescore tennis). Une astuce ? merci d’avance, Lionel Hello everyone, I am looking to set up a RESET button that would allow me to reassign values ​​to certain cells. Is it possible to make a blank cell? I easily manage to reset to 0 but the number 0 poses a problem for me compared to the different formulas of the project (Livescore tennis). A tip? thanks in advance, Lionel ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [August 26, 2021, 5:23pm UTC](https://community.glideapps.com/t/set-column-values/30985/2 "2021-08-26T17:23:22Z")
Yes you could do that with the Action Set Column Values → Clear Value. I would recommend to start with a custom action and then from there same thing… Set Column Values → Clear Value. ---
**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, 5:36pm UTC](https://community.glideapps.com/t/set-column-values/30985/3 "2021-08-26T17:36:54Z")
Awesome 🙂 I take this opportunity to ask another question 🙂 When I add a new match from the app, a new line is automatically created on my Sheet BUT this new line does not have the formulas of the previous ones … So a lot of info is missing: / Any idea to keep the formulas when adding rows to Sheet? On Excel it’s simple we can convert a set of cells into TABLE but I can’t find how to do it on Sheet. Thanks thanks thanks 🙂 ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [August 26, 2021, 5:45pm UTC](https://community.glideapps.com/t/set-column-values/30985/4 "2021-08-26T17:45:12Z")
For that you should use arrayformula. What type of formulas are you using? Perhaps there is a better way to do those calculations inside Glide instead of Google Sheets. ---
**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, 6:22pm UTC](https://community.glideapps.com/t/set-column-values/30985/5 "2021-08-26T18:22:28Z")
Thank you. Here is a screenshot with an example of formula. Columns BCIJQ are all 6 formulas. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/d/4d91b480eb75c2df53a8c07ee32dc4c3246e124c.png) ---
**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, 7:50pm UTC](https://community.glideapps.com/t/set-column-values/30985/6 "2021-08-26T19:50:38Z")
Bonjour, Pour cela, il faut utiliser un “arrayformula” : [https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727) ---
**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, 8:04pm UTC](https://community.glideapps.com/t/set-column-values/30985/7 "2021-08-26T20:04:51Z")
Merci Alexis, je sais que je dois passer par là mais j’ai beau transformé mes formules (qd j’y arrive car pour certaine ça bloque) mais ça ne veut pas. C’est fou l’array fonctionne et d’une cellule toutes s’autoremplissent mais quand je crée une nouvelle ligne (soit en ajoutant depuis l’app Glide sur laquelle je bosse - soit directement en insérant sous Sheet) … nada 😕 ---
**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, 8:05pm UTC](https://community.glideapps.com/t/set-column-values/30985/8 "2021-08-26T20:05:54Z")
Tu peux nous mettre une copie de ta Google Sheet? ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [August 26, 2021, 8:09pm UTC](https://community.glideapps.com/t/set-column-values/30985/10 "2021-08-26T20:09:20Z")
@Lionel_Janus I understand that you want to create a filter where if the date is today then yes, else no? If so, you can do that in Glide with an If-Then-Else. ---
**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, 8:12pm UTC](https://community.glideapps.com/t/set-column-values/30985/11 "2021-08-26T20:12:35Z")
Thank you Santiago? Nope the formula is ok and works great. I have an arrayformula issue then. I have 6 columns with formula but I am desperate to make them automatic so when I send a new input through the app (or insert new lines in Sheet) the formulas are still there so everything works fine… But I am stucked 😕 Cheers, Lionel ---
**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, 8:16pm UTC](https://community.glideapps.com/t/set-column-values/30985/12 "2021-08-26T20:16:25Z")
[my Sheet copy](https://docs.google.com/spreadsheets/d/1QyC018cVEgf--M2TsBMrdkEjuma6mh58WrcsRHV6CtQ/edit?usp=sharing) All formulas are back to original as I haven’t succeed with the arrayformula until now… ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 26, 2021, 8:26pm UTC](https://community.glideapps.com/t/set-column-values/30985/13 "2021-08-26T20:26:41Z")
What a few of us are pointing out is that you can perform this functionality directly within glide. It will be much easier and much quicker as I point out in this other post from earlier today. > [@Speed optimization](https://community.glideapps.com/t/speed-optimization/30978/5): > > Preferably you would move any calculations into glide columns so they calculate instantly in real time directly on the user’s device instead of values having to sync from the app, to the glide server, then to the google sheet, where it calculates and returns the value to the glide server and then back to the app. If the sheet calculations happen quickly enough, the values should be returned to the app within 5 seconds or so. If they take longer, then the resync may miss the updated values. Un… Trying to use formulas in google sheets adds a lot of unnecessary complication unless you absolutely need those formula driven values to be in the google sheet for uses outside of the app. From the looks of what you are trying to do, your formulas appear to be very basic, so would be very easy to accomplish with built in glide functionality. It’s definitely worth the simplicity and the instant speed results compared to waiting for the google sheet to update and sync back to glide. Arrayformulas in the google sheet are fine, but it will create lag in your app and require you to make sure that you delete all empty rows in the sheet for it to work properly. ---
**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, 8:32pm UTC](https://community.glideapps.com/t/set-column-values/30985/14 "2021-08-26T20:32:26Z")
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 ! Cheers ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 26, 2021, 8:33pm UTC](https://community.glideapps.com/t/set-column-values/30985/15 "2021-08-26T20:33:54Z")
All you do is create the additional columns within glide in the same sheet, then change your components to use those new columns. That should be it. Once you are comfortable that everything works, then you can delete those unused formula columns in your google sheet. ---
**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, 8:35pm UTC](https://community.glideapps.com/t/set-column-values/30985/16 "2021-08-26T20:35:59Z")
Ok I will have a serious look at it then 🙂 ---
**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, 8:42pm UTC](https://community.glideapps.com/t/set-column-values/30985/17 "2021-08-26T20:42:16Z")
Tu peux tester ? ---
**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, 8:57pm UTC](https://community.glideapps.com/t/set-column-values/30985/18 "2021-08-26T20:57:42Z")
Non pas pu m’y mettre et je ne sais pas par quel bout le prendre. Je ne sais pourquoi mais ça me parait super compliqué! Je ne vois comment mes cellules concatener par ex afin de pouvoir afficher un certain nombre d’infos visées vont pouvoir fonctionner si je passe uniquement par Glide… Et je vais raccrocher l’ordi pour ce soir si je ne veux pas divorcer :))))) ---
**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, 8:59pm UTC](https://community.glideapps.com/t/set-column-values/30985/19 "2021-08-26T20:59:54Z")
Ohhhh j’avais pas vu que tu avais joué sur la copie ! je vais regarder ça tout de suite 🙂 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 26, 2021, 9:01pm UTC](https://community.glideapps.com/t/set-column-values/30985/20 "2021-08-26T21:01:17Z")
Every formula you have is pretty much the equivalent of an IF column or a Template column in glide. > **[If → Then → Else Column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/if-then-else)** > > Compute different values depending on other data in your sheet > **[Template Column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/template-column)** > > Create labels or messages based on other columns in your table ---
**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:08pm UTC](https://community.glideapps.com/t/set-column-values/30985/21 "2021-08-26T21:08:17Z")
Thank you Jeff - I will take the time to understand how Glide works by itself 😉 [Next page](https://community.glideapps.com/t/set-column-values/30985.md?page=2)