topic Re: Column Formula - Random from custom list of values in Discussions

Column Formula - Random from custom list of values

tom_abramov — Wed, 04 Sep 2019 11:23:14 GMT

Hi,

I have a list of values.

I would like to create a column with formula that will return random value from that list.

Is it possible?

Thank you.

Mark_Bailey — Wed, 04 Sep 2019 12:00:34 GMT

You can use this example:

t1 = {23, 45, 67, 89, 91};
t1[Random Integer( 1, 5 )];

Edit the list to contain your values. Copy this expression and paste it into the Formula Editor.