I’ve got a problem with the update of Google Sheets. I have an App that shows different content each day. To update the content each day, I use a column with the function today() in sheet.
I thought, at midnight each day the date will change to the current one. This however is somehow not the case. I always have to open the sheet (or write something in the sheet) and only then it updates the content.
Not: I have set the settings to “Update at change and hourly” in sheets.
What can I do so that I don’t have to open sheets every day at 00:00 to update my App
Thank you a lot!