# Time relevant formulas

**URL:** <https://community.glideapps.com/t/time-relevant-formulas/30095>\
**Category:** Ask for Help\
**Created:** [August 6, 2021, 10:56am UTC](https://community.glideapps.com/t/time-relevant-formulas/30095 "2021-08-06T10:56:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jordan\_Potts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jordan_potts/32/21359_2.png) [@Jordan\_Potts](https://community.glideapps.com/u/Jordan_Potts)\
**Post date:** [August 6, 2021, 10:56am UTC](https://community.glideapps.com/t/time-relevant-formulas/30095/1 "2021-08-06T10:56:55Z")

</div>

I want a figure to add the same figure to itself every week. For example  
Week 1: 100  
Week 2: 200 (100+100)  
Week 3: 300 (200+100)

Does anyone have any suggestions? 🙂

---

<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:** [August 6, 2021, 11:50am UTC](https://community.glideapps.com/t/time-relevant-formulas/30095/2 "2021-08-06T11:50:04Z")

</div>

How are you currently adding rows for Week 2 and Week 3?

---

<div class="post-metadata">

**Author:** ![Jordan\_Potts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jordan_potts/32/21359_2.png) [@Jordan\_Potts](https://community.glideapps.com/u/Jordan_Potts)\
**Post date:** [August 6, 2021, 12:21pm UTC](https://community.glideapps.com/t/time-relevant-formulas/30095/3 "2021-08-06T12:21:51Z")

</div>

There’s currently only one row containing all of the values, so there is a “rent” column with a value but then I want this to increase on a weekly basis as the rent figure is used to show a ‘live’ income figure if that make sense…

---

<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:** [August 6, 2021, 12:42pm UTC](https://community.glideapps.com/t/time-relevant-formulas/30095/4 "2021-08-06T12:42:31Z")

</div>

So say you have one row and multiple columns of week 1, 2, 3, etc.?

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/time-relevant-formulas/30095/5 "2024-01-17T16:51:03Z")

</div>