How do I formula in Glide?

Ask for Help
1

This is such a dummy question, but I can’t figure out how to do basic formula cell functions in Glide. Even with Excel formulas.

I just want to “Copy down” a formula that continually adds to the value above it. But Glide only seems to want to work to the right. I can’t get formulas to work “down”.

Sample of what I want in gSheets is attached. Base value in B2. Add value from D2 to the total and continually down B3, B4, B5, etc. How do I do this IN GLIDE (not gsheets, since it’s a calculator and values will be dynamic). Thanks

image
image1066×457 26.1 KB

2

Your D2 value is empty though. Do you mean F2?

3

Do you only have the one house and condo or do you have a record of them?

4

It’s all user specific values since it functions only as a “calculator”. So no records.

The user inputs their own custom values that I run some math on in the other columns. Then compare them on a chart.

But the crux of what I can’t figure how to do is simply “Add down” those values like the most basic gSheet or excel formula.

@ThinhDinh Yes F2 is the target. But could be any target.

5
  • Number your rows, from 0-N
  • Create a Math column that is House + N * 200, where N is the Row Number
2 Likes
6

Then you’d simply need 1 or 2 helper tables.

I say 2 because 1 table could be where user is entering data and the 2nd would be the calculations that @Darren_Murphy mentioned above (using single value columns to bring in the entered values)

This will help:

1 Like