# Sheet update at midnight (automatization)

**URL:** <https://community.glideapps.com/t/sheet-update-at-midnight-automatization/54374>\
**Category:** Ask for Help\
**Created:** [November 17, 2022, 3:00pm UTC](https://community.glideapps.com/t/sheet-update-at-midnight-automatization/54374 "2022-11-17T15:00:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ninjaa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ninjaa/32/39698_2.png) [@Ninjaa](https://community.glideapps.com/u/Ninjaa)\
**Post date:** [November 17, 2022, 3:00pm UTC](https://community.glideapps.com/t/sheet-update-at-midnight-automatization/54374/1 "2022-11-17T15:00:31Z")

</div>

Hey people,

I’ve got a problem with the **update of Google Sheets**. I have an App that shows different content each day. To update the content each day, I use a column with the function **today()** in sheet.

I thought, at midnight each day the date will change to the current one. This however is somehow not the case. I always have to open the sheet (or write something in the sheet) and only then it updates the content.

Not: I have set the settings to “Update at change and hourly” in sheets.

What can I do so that I don’t have to open sheets every day at 00:00 to update my App 😃

Thank you a lot!  
Ninja

---

<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:** [November 17, 2022, 3:14pm UTC](https://community.glideapps.com/t/sheet-update-at-midnight-automatization/54374/2 "2022-11-17T15:14:58Z")

</div>

> [@Ninjaa](#):
>
> To update the content each day, I use a column with the function **today()** in sheet.

Yeah, that’s not a very good idea 😉

You don’t need to do anything in Google Sheets for this.  
To replicate your “today” column, create a Math column in Glide and use the special “Now” value as a replacement value:

 ![Screen Shot 2022-11-17 at 11.14.17 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/0/5008bdb3e2c7e89bc7075981ad03f95d535b8d52.png)

---

<div class="post-metadata">

**Author:** ![Ninjaa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ninjaa/32/39698_2.png) [@Ninjaa](https://community.glideapps.com/u/Ninjaa)\
**Post date:** [November 19, 2022, 11:16pm UTC](https://community.glideapps.com/t/sheet-update-at-midnight-automatization/54374/3 "2022-11-19T23:16:09Z")

</div>

Haha… Nice! Thank you 😃