# Formulas in glide table

**URL:** <https://community.glideapps.com/t/formulas-in-glide-table/39796>\
**Category:** Ask for Help\
**Created:** [March 17, 2022, 8:25pm UTC](https://community.glideapps.com/t/formulas-in-glide-table/39796 "2022-03-17T20:25:21Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![popina](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/popina/32/17164_2.png) [@popina](https://community.glideapps.com/u/popina)\
**Post date:** [March 17, 2022, 8:25pm UTC](https://community.glideapps.com/t/formulas-in-glide-table/39796/1 "2022-03-17T20:25:21Z")

</div>

Hi, I am trying to increment numbers in cells of a column with a formula. For example, when I increment a cell by +1, then I need the cells bellow in that column to do the same. I am able to do that in google sheets, but he reponse is very slow so the change in the app is not immediate. Does anyone know how to do that in a glide table?

---

<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 18, 2022, 12:21am UTC](https://community.glideapps.com/t/formulas-in-glide-table/39796/2 "2022-03-18T00:21:23Z")

</div>

So do you want to increment only cells “below” the changed cell, or should all cells in the same column, except the changed cell, be incremented?

---

<div class="post-metadata">

**Author:** ![popina](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/popina/32/17164_2.png) [@popina](https://community.glideapps.com/u/popina)\
**Post date:** [March 18, 2022, 2:04am UTC](https://community.glideapps.com/t/formulas-in-glide-table/39796/3 "2022-03-18T02:04:45Z")

</div>

Hi! Thanks for your answer. Ideally I would like to increment only the cells below. But if that is not possible, is there a way to increment all of them except the changed one? Thanks!

---

<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 21, 2022, 12:21am UTC](https://community.glideapps.com/t/formulas-in-glide-table/39796/4 "2022-03-21T00:21:12Z")

</div>

For now I don’t think I have a good answer to this. A pseudo-idea is that we store a list of rowIDs that are “below” each cell and for every increment action, we send those IDs to an external service like Integromat/Make, finally sequentially call the Glide API to increment those rows.

The challenges to this are:

- How to construct the array of “below” rowIDs
- How to construct the array of “adjusted values” in anticipation of the increment. You can’t increment a value through an API call, so you have to calculate them in advance.

Can we know more about your use case for this?

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [March 21, 2022, 2:47am UTC](https://community.glideapps.com/t/formulas-in-glide-table/39796/5 "2022-03-21T02:47:35Z")

</div>

Hola,

I think I can help Thinh with this and I imagine @popina wants something like this :

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/2/c2990d2966377dd4eab6ffc5fada66814c866a2e.png)

I called Delta (Δ+) your increment value and when it appears, the numbers bellow should have a new sequence based on that Delta right?

This is not a no-code solution of course but some times we have to apply the plan B 😉

In the end, you are going to create 4 new computed columns to gather some info and help the JS code I developed to carry out this:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d3dc02c557e7cfa751de117d78170d67a83c0f19.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f72a790a02876f889a658cc832b1fb985ed2e6a4.png)

But to help you better, here you can see the demo APP and copy the logic about it: [https://scenic-week-7511.glideapp.io/](https://scenic-week-7511.glideapp.io/)

I hope it helps you, feliz noche!

---

<div class="post-metadata">

**Author:** ![popina](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/popina/32/17164_2.png) [@popina](https://community.glideapps.com/u/popina)\
**Post date:** [March 21, 2022, 1:50pm UTC](https://community.glideapps.com/t/formulas-in-glide-table/39796/6 "2022-03-21T13:50:14Z")

</div>

Gracias Gustavo!! 🙂
