# 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:** 1\ **Showing post:** 13
**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. --- _[View the full topic](https://community.glideapps.com/t/set-column-values/30985)._