# How do I formula in Glide?

**URL:** https://community.glideapps.com/t/how-do-i-formula-in-glide/72181
**Category:** Ask for Help
**Created:** [March 30, 2024, 1:20am UTC](https://community.glideapps.com/t/how-do-i-formula-in-glide/72181 "2024-03-30T01:20:55Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![HouseHippo](https://avatars.discourse-cdn.com/v4/letter/h/6f9a4e/32.png) [@HouseHippo](https://community.glideapps.com/u/HouseHippo)
#### Post date: [March 30, 2024, 1:20am UTC](https://community.glideapps.com/t/how-do-i-formula-in-glide/72181/1 "2024-03-30T01:20:55Z")

</div>

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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/0/70f15e4c25bb234e2ef2940b88b13a5d50b6dbbb.png)

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 30, 2024, 2:00am UTC](https://community.glideapps.com/t/how-do-i-formula-in-glide/72181/2 "2024-03-30T02:00:31Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [March 30, 2024, 2:54am UTC](https://community.glideapps.com/t/how-do-i-formula-in-glide/72181/3 "2024-03-30T02:54:27Z")

</div>

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

---

<div class="post-metadata">

### Author: ![HouseHippo](https://avatars.discourse-cdn.com/v4/letter/h/6f9a4e/32.png) [@HouseHippo](https://community.glideapps.com/u/HouseHippo)
#### Post date: [March 30, 2024, 3:24am UTC](https://community.glideapps.com/t/how-do-i-formula-in-glide/72181/4 "2024-03-30T03:24:21Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 30, 2024, 3:41am UTC](https://community.glideapps.com/t/how-do-i-formula-in-glide/72181/5 "2024-03-30T03:41:38Z")

</div>

- Number your rows, from 0-N
- Create a Math column that is `House + N * 200`, where N is the Row Number

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [March 30, 2024, 3:42am UTC](https://community.glideapps.com/t/how-do-i-formula-in-glide/72181/6 "2024-03-30T03:42:59Z")

</div>

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:

> [@litter\_in\_bin\_sign Trash your Excel Formulas](https://community.glideapps.com/t/trash-your-excel-formulas/55788):
>
> wave Hey Gliders! By request, I created a video that explains how to replace 14 commonly used Google Sheet/Excel Formulas using Glide computed columns and other native Glide functionality. Formulas are timestamped in the description. For good measure, I also threw in how to use the Excel Formula plugin column upside_down_facepopcorn Enjoy! [[Glide: Replace 14 Excel Formulas with Glide Computed Columns] ](https://www.youtube.com/watch?v=YITKadLUKNE)
