Sum formula

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 ?

https://docs.glideapps.com/all/reference/using-sheets/functions/arrayformula

2 Likes

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

2 Likes

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.

1 Like

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!

1 Like

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.

1 Like