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 strange. 43s video here https://share.vidyard.com/watch/XxDZxRL3foQ6z88A3FPHDn? [image] Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help 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 …

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	3707	July 28, 2022
Add new row is clearing my Google Sheet formula Ask for Help	5	833	September 3, 2021
Google Sheet Entries keep going to bottom of sheet in my glide app Report a Bug	10	752	October 16, 2022
Doesn't write on my Google Sheet Ask for Help	4	1892	January 25, 2020
How do you add functions to rows you add with glide? Ask for Help	5	2465	October 5, 2020

Sum formula

Related topics