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 ?

[image] Glide 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! [image] FORM data writing to Glide but NOT to Google Sheet Report a Bug Very st…

If you can perform the math with the glide math column, that will be much easier.

Hello sir, can you tell me how we do the calculation in glide. THANK YOU

Use the math column, Create expression and define the variables with columns you want.

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.

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.

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.

Thanks Jeff-This was very helpful!

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.

Sum formula

Ask for Help

Jeff_Hager July 7, 2020, 10:26pm 2

Topic		Replies	Views
Google Sheets Formula Carry Down Ask for Help	13	3631	July 28, 2022
Add new row is clearing my Google Sheet formula Ask for Help	5	813	September 3, 2021
Google Sheet Entries keep going to bottom of sheet in my glide app Report a Bug	10	716	October 16, 2022
Doesn't write on my Google Sheet Ask for Help	4	1873	January 25, 2020
How do you add functions to rows you add with glide? Ask for Help	5	2416	October 5, 2020

Sum formula

Related topics