# Sum formula **URL:** \ **Category:** Ask for Help\ **Created:** [July 7, 2020, 10:19pm UTC](https://community.glideapps.com/t/sum-formula/12131 "2020-07-07T22:19:11Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Pole\_Mobilite](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pole_mobilite/32/5593_2.png) [@Pole\_Mobilite](https://community.glideapps.com/u/Pole_Mobilite)\ **Post date:** [July 7, 2020, 10:19pm UTC](https://community.glideapps.com/t/sum-formula/12131/1 "2020-07-07T22:19:11Z")
Hello, I am encountering a problem. I created formulas in my googlesheet. But when I fill a form in the glide application, the form data goes below the line while I want it to be placed in the line where the formula is located. There is a solution ? ---
**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:** [July 7, 2020, 10:26pm UTC](https://community.glideapps.com/t/sum-formula/12131/2 "2020-07-07T22:26:04Z")
> **[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! > [@FORM data writing to Glide but NOT to Google Sheet](https://community.glideapps.com/t/form-data-writing-to-glide-but-not-to-google-sheet/12076): > > Very strange. 43s video here [https://share.vidyard.com/watch/XxDZxRL3foQ6z88A3FPHDn](https://share.vidyard.com/watch/XxDZxRL3foQ6z88A3FPHDn)? > [@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 … ---
**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:** [July 7, 2020, 10:27pm UTC](https://community.glideapps.com/t/sum-formula/12131/3 "2020-07-07T22:27:44Z")
If you can perform the math with the glide math column, that will be much easier. ---
**Author:** ![Pole\_Mobilite](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pole_mobilite/32/5593_2.png) [@Pole\_Mobilite](https://community.glideapps.com/u/Pole_Mobilite)\ **Post date:** [July 8, 2020, 7:56am UTC](https://community.glideapps.com/t/sum-formula/12131/4 "2020-07-08T07:56:47Z")
Hello sir, can you tell me how we do the calculation in glide. THANK YOU ---
**Author:** ![SP\_007](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sp_007/32/117_2.png) [@SP\_007](https://community.glideapps.com/u/SP_007)\ **Post date:** [July 8, 2020, 8:14am UTC](https://community.glideapps.com/t/sum-formula/12131/5 "2020-07-08T08:14:06Z")
Use the math column, Create expression and define the variables with columns you want. ---
**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:** [July 8, 2020, 8:27am UTC](https://community.glideapps.com/t/sum-formula/12131/6 "2020-07-08T08:27:07Z")
What calculation do you want to make, is it just a sum of multiple columns? If so you can make a math column and do the things as @SP_007 said above. ---
**Author:** ![Pole\_Mobilite](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pole_mobilite/32/5593_2.png) [@Pole\_Mobilite](https://community.glideapps.com/u/Pole_Mobilite)\ **Post date:** [July 8, 2020, 8:40am UTC](https://community.glideapps.com/t/sum-formula/12131/7 "2020-07-08T08:40:28Z")
thank you so much, But this is where I run into the problem, I don’t know what expression to create for the creation of the column. ---
**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:** [July 8, 2020, 8:42am UTC](https://community.glideapps.com/t/sum-formula/12131/8 "2020-07-08T08:42:13Z")
You go to the Editor, create a new column and choose the “Math” type. In the “Expression” part, type in whatever you need to calculate. Let’s say: ``` Quantity1 + Quantity2 + Quantity3 ``` Then below that for the replace part, point the “Quantity1” to its column, same for the other variables. ---
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [July 8, 2020, 10:40am UTC](https://community.glideapps.com/t/sum-formula/12131/9 "2020-07-08T10:40:57Z")
Thanks Jeff-This was very helpful! ---
**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:** [July 8, 2020, 10:54am UTC](https://community.glideapps.com/t/sum-formula/12131/10 "2020-07-08T10:54:53Z")
If you have further questions about that Arrayformula post feel free to tell me. I have written about Query as well but make sure you get Arrayformula first and simplify your sheets.