Real random list

Hi guys and anyone who is reading it. This is how I did it. I added a new column to my articles tab and added =RANDBETWEEN(1,1000) formula. This created a random number between 1 and 1000 for each article.

In file->spreadsheet settings->calculation I set it to re-calculate every minute.

On inline sort settings I set it to sort by order of the random number descending or ascending isn’t important in this case. And vualá! I have an actual random list of articles each time I load an article. Thank you for all your help!!

More info:

Screen Shot 2020-09-28 at 12.31.09 PM|411x500

5 Likes