I am trying to get my home screen image to update every minute as follows:
I have an “Image” Column (D) with all image URLs.
I have a home screen Column (A), in the only cell of home screen Column (A)
I have the following formula: =index(D2:D,randbetween(1,counta(D2:D)))
The formula selects an image URL from Column (D) and returns the image URL to
Column (A) which in turn updates my home screen cover image.
I set the refresh time as follows:
Spreadsheet Settings >calculate > on change and every minute.
Glide does not automatically update my home screen image. The formula works
if I manually refresh the spreadsheet in glide, would a pro account work?