super noob question, but how can I set up to pick one random image from a column?
Hi Nicola, welcome to the community.
No, I don’t think this is a noob question at all. There are several ways you can achieve this, I’m gonna give you one way to do it.
So you have an “Image” column with all the URLs. Create one new column, I assume you want to display it in an image component, let’s call that “Featured”. In the only cell of the featured column put the following formula, assuming you store the images in column A.
=index(A2:A,randbetween(1,counta(A2:A)))
This formula will grab all the rows containing images from cell A2 to the last cell containing data in column A, then randomly pick an index integer, which returns the URL of image in question via the INDEX formula.
2 Likes
That’s awesome! Thank you!
Does this formula refresh every time I load/open the app?
1 Like
You can determine when it refreshes by going to Spreadsheet Settings->calculate and choose whether you want it to refresh on change only, on change and every hour or on change and every minute
1 Like
Can you try Ofer’s way above and see if it works?
Yeah it works!!! Thank you!
1 Like