Even with script, I believe that it won’t register the change as a “spreadsheet edit”. So the sheet would change but the app won’t. This is the same for both NOW and TODAY formulas.
I had suggested a feature be built within Glide to provide a new data column type called Current DateTime—go upvote!