Formula is not updated on poage load

[arminus]

Describe the bug
I have this formula for column 'Offen'
IF({Erstattung}> 0, 0, DATETIME_DIFF(TODAY(),{Eingereicht}))
Column Erstattung is a number and Eingereicht is a Date. The formula works correctly when either Erstattung or Eingereicht changes, but does not get refreshed/recalculated otherwise.

To Reproduce
Steps to reproduce the behavior:

1. Loaded a table where the values in 'Offen' were clearly wrong
2. Changed the date in the first row from 15/4/2025 to 14/4/2025 -> the 'Offen' value for that row was updated
3. Changed it back to 15/4/2025 to clearly show the difference to the row in which the value of 'Offen' is not refreshed (see screenshot below) with then two different values for the same date

Expected behavior
All formula results to be updated on page load

Screenshots

Client (please complete the following information):

• OS: Windows10
• Browser Firefox
• Version 1.138

Platform (Please tell us which deployment version you are using)
selfhosted docker ghcr.io/teableio/teable:latest

Additional context
Add any other context about the problem here.

[tea-artist]

The current calculations of formulas occur when they are written, so they won't automatically change. Of course, this is an issue in the context of dates, and we will look for a solution in the future.

[tea-artist]

#1756