Random creates a random number between 0 and 1 and when set to "true" it updates with every doc edit. Multiplying by Table.Count() multiplies that number by the number of rows in a particular table, which bumps this random number over 1.
2.RoundUp(Random(true) * Table.Count())
2
RoundUp() just makes this a nice whole number to work with.
This Table.Nth() formula takes the row number with the number being what's generated in step 2. You can see how in Step 3 the result is highlighted in blue as a row reference that you can hover on instead of just a number.
Random Numbers
0
Random Numbers
Random Numbers
1
7
2
4
3
3
There are no rows in this table
Numbers
0
Number
Number
1
1
2
2
3
3
4
4
5
5
6
6
7
7
8
8
9
9
There are no rows in this table
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
