# Previous Days Value

**URL:** <https://community.glideapps.com/t/previous-days-value/73438>\
**Category:** Ask for Help\
**Created:** [May 16, 2024, 6:10pm UTC](https://community.glideapps.com/t/previous-days-value/73438 "2024-05-16T18:10:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aiden\_Anderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aiden_anderson/32/67692_2.png) [@Aiden\_Anderson](https://community.glideapps.com/u/Aiden_Anderson)\
**Post date:** [May 16, 2024, 6:10pm UTC](https://community.glideapps.com/t/previous-days-value/73438/1 "2024-05-16T18:10:06Z")

</div>

I have a score column that is automatically updating from a google sheet every 20 mins. I want to have another column that shows the score column value from the previous day at 9am. It would then update daily. Is this possible?

---

<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:** [May 16, 2024, 8:32pm UTC](https://community.glideapps.com/t/previous-days-value/73438/2 "2024-05-16T20:32:02Z")

</div>

If you use Google App Script, ya. If I understand fully correctly, you can set a trigger that runs the script every day at 9:00am to save the value to a column of your choosing.