Choose Language Hide Translation Bar
Highlighted
tom_abramov
Level V

Column Formula - Random from custom list of values

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Column Formula - Random from custom list of values

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.

Learn it once, use it forever!

View solution in original post

1 REPLY 1
Highlighted

Re: Column Formula - Random from custom list of values

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.

Learn it once, use it forever!

View solution in original post

Article Labels

    There are no labels assigned to this post.