# Insert Formulas with the Insert row action **URL:** \ **Category:** Ask for Help\ **Created:** [June 28, 2021, 10:24am UTC](https://community.glideapps.com/t/insert-formulas-with-the-insert-row-action/28438 "2021-06-28T10:24:46Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Thibault\_Milan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibault_milan/32/4970_2.png) [@Thibault\_Milan](https://community.glideapps.com/u/Thibault_Milan)\ **Post date:** [June 28, 2021, 10:24am UTC](https://community.glideapps.com/t/insert-formulas-with-the-insert-row-action/28438/1 "2021-06-28T10:24:46Z")
Hello everyone, For better performances, I which to be able to insert formulas while using the insert row action. I had this formula at first : `=TEXT(B2,"YYYY-MM-DD")` Which I changed into `=TEXT(INDIRECT(ADDRESS(ROW(),2)),"YYYY-MM-DD")` so it works whatever line it is used, but when I put that in the “custom content” of the insert row, it inserts it with a `'` just before so it’s rendered as text and not evaluated. `'=TEXT(INDIRECT(ADDRESS(ROW(),2)),"YYYY-MM-DD")` Any idea? I want to avoid relying on Google Scripts since it’s too slow to run for my users to see an instant change on the app. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 28, 2021, 11:06am UTC](https://community.glideapps.com/t/insert-formulas-with-the-insert-row-action/28438/2 "2021-06-28T11:06:29Z")
From what you wrote I believe arrayformula will solve your problem. Put this in your first row (header row). ```auto ={"Formatted date";ARRAYFORMULA(IF(B2:B<>"",TEXT(B2:B,"YYYY-MM-DD"),""))} ``` Regarding the insert row action, it’s working the right way because it’s suppose to insert text/number, not a formula. ---
**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 28, 2021, 11:15am UTC](https://community.glideapps.com/t/insert-formulas-with-the-insert-row-action/28438/3 "2021-06-28T11:15:12Z")
> [@Thibault\_Milan](#): > > Any idea? I want to avoid relying on Google Scripts since it’s too slow to run for my users to see an instant change on the app. If you want an instant change in your app, then I’d advise investigating replacing the GSheet formula with Glide computed columns. When you are relying on GSheet formulas, this is what happens: - A user makes a change in your app - That change then needs to sync with the Glide cloud servers - The change is then written to your GSheet - The GSheet formula calculates the result - The result syncs back to the Glide cloud servers - And finally, the result syncs back to the users device That whole sequence can take anywhere between several seconds and several minutes. In comparison, when you use Glide computed columns, the sequence is as follows: - User makes a change in the app - Result is calculated on the users device, and is available immediately. ---
**Author:** ![Thibault\_Milan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibault_milan/32/4970_2.png) [@Thibault\_Milan](https://community.glideapps.com/u/Thibault_Milan)\ **Post date:** [June 28, 2021, 11:25am UTC](https://community.glideapps.com/t/insert-formulas-with-the-insert-row-action/28438/4 "2021-06-28T11:25:49Z")
> [@Darren\_Murphy](#): > > If you want an instant change in your app, then I’d advise investigating replacing the GSheet formula with Glide computed columns. Well, I’m quite aware of the benefits of Glide columns 😛 but : 1. There’s no easy way to migrate from Gsheet to Glide columns 2. I need people to access those data outside of Glide; that’s the main benefit of Glide. Otherwise, it’s just Delphi but prettier 3. Glide computed columns are very poor in terms of what you can do with it, which doesn’t cover my needs (and trust me, I would be more than happy to move a lot of my formulas into glide columns 😁) ---
**Author:** ![Thibault\_Milan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibault_milan/32/4970_2.png) [@Thibault\_Milan](https://community.glideapps.com/u/Thibault_Milan)\ **Post date:** [June 28, 2021, 11:45am UTC](https://community.glideapps.com/t/insert-formulas-with-the-insert-row-action/28438/5 "2021-06-28T11:45:46Z")
OMG That’s just perfect. How did I missed that. Gonna solve so many of my troubles. Thank you a million! ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/insert-formulas-with-the-insert-row-action/28438/6 "2024-01-17T16:51:43Z")