On my home screen, I’m trying to display the current date in a string of text in a rich text field. I have the date being calculated as now() in field x2 in the the spreadsheet, and calculating the text string including the result of that date field.
“
”&TO_TEXT(X2) &“
”& T2&“
The trouble is the date doesn’t seem to update unless I open the spreadsheet. Is there a way to make the date update every morning?