I have a Google Form that fills up a new line with values in Sheet1!, column A and column B.
I am trying to create an
=ARRAYFORMULA function in column C, which will populate the C cell in each new line created by the form with a random value, fetched from an array of cells in
The closest I got to doing it is with this array formula I placed in
It indeed enters a random value from
Sheet2!A1:A8, however, the problem is that it changes all the previous values in column C to the same new random value it fetches for each new line created by the form.
What I need is that each new line created by the form will receive a different random value from the array.
Any ideas anyone?