# Google Sheets Formula Carry Down **URL:** \ **Category:** Ask for Help\ **Created:** [December 31, 2020, 3:45pm UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546 "2020-12-31T15:45:21Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Craig\_Greiner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/craig_greiner/32/12306_2.png) [@Craig\_Greiner](https://community.glideapps.com/u/Craig_Greiner)\ **Post date:** [December 31, 2020, 3:45pm UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546/1 "2020-12-31T15:45:21Z")
I have an app that incorporates about 20 columns (each a formula) for each new row. I want to enable users to add a new entry in column A to the sheet and have the formulas carry down. However, I have yet to find a simple way to do this. When a new entry is added, it does not carry down the formula. If I leave column A blank and prepopulate the formula columns, Glide entry comes in after the prepopulated rows. Any help would be appreciated - in particular one that does not force me to reconfigure the entire app. I think this can be done with a second sheet but worry about reconfiguring the entire app. I should add the the formulas are based on stock market data so I need to ensure I do not break the ability for the sheet to auto refresh (this is a pro account). ---
**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:** [December 31, 2020, 4:12pm UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546/2 "2020-12-31T16:12:24Z")
I would recommend learning about arrayformulas. But if possible, my higher recommendation would be to attempt to built the logic using glide columns in the data editor. It much easier and the app responds much faster than waiting for data to sync to the sheet, update with a formula, then sync back to the app. Glide columns update instantly on the user’s device. > [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727): > > Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. > > > **1/ Definition** > > > > Arrayformula is defined as “a range, mathematical expression using one cell range … > **[Glide Docs](https://www.glideapps.com/docs)** > > Welcome to Glide Docs, a steadily growing collection of articles and videos on how to use Glide. We can’t wait to see what you build! ---
**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:** [December 31, 2020, 4:29pm UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546/3 "2020-12-31T16:29:47Z")
Can we know more about the formulas you’re trying to use here? Probably we can find a way for you to have it inside Glide. ---
**Author:** ![Craig\_Greiner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/craig_greiner/32/12306_2.png) [@Craig\_Greiner](https://community.glideapps.com/u/Craig_Greiner)\ **Post date:** [December 31, 2020, 10:08pm UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546/4 "2020-12-31T22:08:33Z")
The formulas almost all call one of the Google sheets built in stock market functions. For that reason I do not think the glide calculation columns will work, or am I wrong? ---
**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:** [January 1, 2021, 12:28am UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546/5 "2021-01-01T00:28:32Z")
Do you use GoogleFinance? ---
**Author:** ![Craig\_Greiner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/craig_greiner/32/12306_2.png) [@Craig\_Greiner](https://community.glideapps.com/u/Craig_Greiner)\ **Post date:** [January 1, 2021, 12:47am UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546/6 "2021-01-01T00:47:26Z")
Yes. ---
**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:** [January 1, 2021, 12:53am UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546/7 "2021-01-01T00:53:59Z")
I think it’s best you use a Script to help with this because GoogleFinance doesn’t work with formulas. You can check out the post Jeff linked above, I did include a script there. ---
**Author:** ![sam1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sam1/32/24823_2.png) [@sam1](https://community.glideapps.com/u/sam1)\ **Post date:** [April 21, 2021, 3:21pm UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546/8 "2021-04-21T15:21:39Z")
hi there, i have issue with a formula.i have a quantity column, a price column and a subtotal column.i used this formula in subtotal column =ARRAYFORMULA(IF(LEN(A2:A),A2:A\*B2:B,"")) and it works perferctly but only when price column format is number ,when i change to currency it doesnt work. any solution? ---
**Author:** ![carlitosuk5](https://avatars.discourse-cdn.com/v4/letter/c/a587f6/32.png) [@carlitosuk5](https://community.glideapps.com/u/carlitosuk5)\ **Post date:** [July 27, 2022, 3:33pm UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546/9 "2022-07-27T15:33:22Z")
Hiya, Was wondering what is the ARRAYFORMULA from of-then glide app to google sheet as we discussed yesterday Thanks in advance ---
**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:** [July 27, 2022, 3:48pm UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546/10 "2022-07-27T15:48:42Z")
Are you asking how to create an arrayformula in a Google Sheet, or are you asking how to create the equivalent of an arrayformula in a Glide Table? If a Glide Table, then the answer is to use a computed column. When you use a computed column, the same computation is automatically applied to every single row in the table. Which one you use depends on the situation. For example, if just want to add two values together, then you would use a math column. If you wanted to concatenate values, then you’d use a template. And so on… Glide has a very rich collection of [computed columns](https://docs.glideapps.com/all/topics/computed-columns/primary) and [plugins](https://www.glideapps.com/plugins). Just about anything you can do with spreadsheet formulas can also be done with Glide Computed columns. ---
**Author:** ![carlitosuk5](https://avatars.discourse-cdn.com/v4/letter/c/a587f6/32.png) [@carlitosuk5](https://community.glideapps.com/u/carlitosuk5)\ **Post date:** [July 27, 2022, 8:40pm UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546/11 "2022-07-27T20:40:47Z")
Hi, Here is the screenshot on the glide table logic meed to replicate the logic in the Sheet, how can I convert the if-then-else logic to an arrayformula? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f7fef8788cb64d91b377776cca9546943710fcc3.png) ---
**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:** [July 28, 2022, 1:05am UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546/12 "2022-07-28T01:05:59Z")
Can you show the configuration of your if-then-else column please? ---
**Author:** ![carlitosuk5](https://avatars.discourse-cdn.com/v4/letter/c/a587f6/32.png) [@carlitosuk5](https://community.glideapps.com/u/carlitosuk5)\ **Post date:** [July 28, 2022, 5:50am UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546/13 "2022-07-28T05:50:40Z")
Hi Yea sure here is a screenshot bellow ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/3/9374560a87ee06cbd331321afd4a4a28ef8f0cea.jpeg) ---
**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:** [July 28, 2022, 5:58am UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546/14 "2022-07-28T05:58:10Z")
That’s exactly the same screenshot, and doesn’t help at all. How is that first column configured, and what determines whether the value is OFF or ON? ---
**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 12, 2024, 1:46am UTC](https://community.glideapps.com/t/google-sheets-formula-carry-down/20546/15 "2024-01-12T01:46:43Z")