Show current date on home screen

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?

This only works with Background Refresh, a Pro feature that updates from your sheet every few minutes.

I have a Pro account for this app.

Then enable Background Refresh in Settings > General.

1 Like

Thanks. I’ll check it in the morning and see how we did. :grinning:

This solved my issue, thanks.

1 Like