# Update Automatically Today Function **URL:** \ **Category:** Ask for Help\ **Created:** [February 19, 2024, 2:43pm UTC](https://community.glideapps.com/t/update-automatically-today-function/70960 "2024-02-19T14:43:44Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Vie\_Sportive\_NBA91](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vie_sportive_nba91/32/71117_2.png) [@Vie\_Sportive\_NBA91](https://community.glideapps.com/u/Vie_Sportive_NBA91)\ **Post date:** [February 19, 2024, 2:43pm UTC](https://community.glideapps.com/t/update-automatically-today-function/70960/1 "2024-02-19T14:43:44Z")
Hi Everyone, I have a lot of Cells on my google sheets with the Today Function. This cells do not update automatically. The only way is to open the files every day… However i chose to calculate all the functions every hour in the settings of my files but i still need to open the files for update. Do you have a solution ? Thanks in advance ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 19, 2024, 2:57pm UTC](https://community.glideapps.com/t/update-automatically-today-function/70960/2 "2024-02-19T14:57:24Z")
Why don’t you take the time now with the math column? ---
**Author:** ![Vie\_Sportive\_NBA91](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vie_sportive_nba91/32/71117_2.png) [@Vie\_Sportive\_NBA91](https://community.glideapps.com/u/Vie_Sportive_NBA91)\ **Post date:** [February 19, 2024, 3:13pm UTC](https://community.glideapps.com/t/update-automatically-today-function/70960/3 "2024-02-19T15:13:12Z")
I do. I use the time now with the math column just for show the time on the app but no updates for all the cells with the today function (for example a cell like : =datedif(A4;TODAY();“d”) doesn’t change automatically every day if i don’t open the files) ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 19, 2024, 3:32pm UTC](https://community.glideapps.com/t/update-automatically-today-function/70960/4 "2024-02-19T15:32:14Z")
What I meant was using calculations within Glide. However, if this is in a spreadsheet, the formula you provided is incorrect. It should be as follows: `=DATEDIF(A4, TODAY(), "d")` . ---
**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:** [February 19, 2024, 3:34pm UTC](https://community.glideapps.com/t/update-automatically-today-function/70960/5 "2024-02-19T15:34:21Z")
You can change how often it is calculated via Spreadsheet Settings → Calculation ![CleanShot 2024-02-19 at 23.32.52@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8e509950c0e4392da538641fed51f62c8f64353c.png) ---
**Author:** ![Vie\_Sportive\_NBA91](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vie_sportive_nba91/32/71117_2.png) [@Vie\_Sportive\_NBA91](https://community.glideapps.com/u/Vie_Sportive_NBA91)\ **Post date:** [February 19, 2024, 3:54pm UTC](https://community.glideapps.com/t/update-automatically-today-function/70960/6 "2024-02-19T15:54:04Z")
All my formula are correct and i put every hour for calculation. I can do the same formula with glide ? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 19, 2024, 5:35pm UTC](https://community.glideapps.com/t/update-automatically-today-function/70960/7 "2024-02-19T17:35:37Z")
Why not use the Math NOW functionality in Glide? That will give you a time that updates every 10 seconds. ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 19, 2024, 11:58pm UTC](https://community.glideapps.com/t/update-automatically-today-function/70960/8 "2024-02-19T23:58:05Z")
> **[Date Difference Column - Glide](https://demo.arcade.software/pQJHCvvkCA3MuAm4gA7y?embed)** ---
**Author:** ![Vie\_Sportive\_NBA91](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vie_sportive_nba91/32/71117_2.png) [@Vie\_Sportive\_NBA91](https://community.glideapps.com/u/Vie_Sportive_NBA91)\ **Post date:** [February 20, 2024, 8:47am UTC](https://community.glideapps.com/t/update-automatically-today-function/70960/9 "2024-02-20T08:47:24Z")
Thanks a lot ! Is it possible with glide to filter data on a new table ? For example i would like all the lines with 100 days in the date difference colonne. ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 20, 2024, 10:54am UTC](https://community.glideapps.com/t/update-automatically-today-function/70960/10 "2024-02-20T10:54:41Z")
I’m not quite sure what you mean by ‘new table.’ You can try it out yourself. If you mean filtering on a collection component, then yes, of course. ---
**Author:** ![Vie\_Sportive\_NBA91](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vie_sportive_nba91/32/71117_2.png) [@Vie\_Sportive\_NBA91](https://community.glideapps.com/u/Vie_Sportive_NBA91)\ **Post date:** [February 24, 2024, 8:42am UTC](https://community.glideapps.com/t/update-automatically-today-function/70960/11 "2024-02-24T08:42:26Z")
Thanks a lot all. I achieved what I wanted to do thanks to you ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [March 2, 2024, 8:43am UTC](https://community.glideapps.com/t/update-automatically-today-function/70960/12 "2024-03-02T08:43:12Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.