Dear all, If I want a random "Quote" or "Wor...

[Jerry_Lan]

Dear all,

If I want a random “Quote” or “Words of Wisdom” for example, I will use randbetween in say column X and sort by column X . This works for excel. But does not not work in google sheet and in Virtual Column formula. Am I correct? I will be on leave soon. Just send this as an info.

[pravse]

Randbetween() works fine with AppSheet.

In Excel, how do you look up a specific row — I guess you sort and then use the random number to find the Nth entry?

You could probably do something similar using the RowNumber column

[Cubyl]

Randbetween work good in a Google sheet too

[Kirk_Masden]

Hi! I wrote about how to do something like this here:

Generating a random number and then one based on that number Questions

Hi! I’m using RandBetween() to make my app pick a quote randomly from a column. That’s easy enough. Let’s say I have 120 quotes and I want to make a slice that will pick out just one record to display in the detail view that is shown when the app is opened. I number the [Key] column from 1 to 120 and used this make the slice: [Key]=RANDBETWEEN(1,120) So far so good. Actually, though, I would like the slice to result in two records – the English quote and a corresponding Japanese translat…