My sheet has a =today() cell that will not update the app. Until the app has been changed.
I trick my app into updating … I ask my users (only family members so far) to ‘check in’ when they are using the app. This changes the spreadsheet after just ONE person ‘checks in’. See here: https://cqacq.glideapp.io
This is just a hobby app, so there is no real need to keep it updated by the minute.
If no one checks in, then no one really wanted the app to update anyway.
Go ahead and try it. Anyone can check in.
ALSO, to make it interesting, I crown the FIRST one to check in as the winner of the day.
(See the menu item - Daily Winner)
ALSO, because is is pulling random cells, every check in changes the random post.