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.
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
Randbetween work good in a Google sheet too
Hi! I wrote about how to do something like this here:
[Generating a random number and then one based on that number](https://community.appsheet.com/t/generating-a-random-number-and-then-one-based-on-that-number/10565) 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…