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 ?
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