If the “Due” column is today’s date write “Action now” in the “Action” column.
I seems to have worked once, but doesn’t seem to thereafter. I did note that the time zone was incorrect, so set that correctly. Perhaps I have to wait until that kicks in, or maybe something else is needed?
Use Grist’s TODAY() function, instead of date.today(). Grist’s TODAY() and NOW() functions are special in that Grist takes care of recalculating formulas that contain them periodically. This happens about once an hour, and only while the document is open.
The Python functon date.today() returns the right value when it’s calculated, but it doesn’t schedule any recalculations, that’s why the cell doesn’t update again.
Ah, yes that makes it work.
Many thanks