title: Applying the random function for every row in google sheets
body: <p>I am trying to make a google sheet that assigns a random alphanumeric sequence to every new row added. However, when I use the rand() function within the array formula the outputs are all the same. I'm wondering if there is any way in order to call RANDALPHA() - a custom function - for each row.</p>
  <p><a href="https://i.stack.imgur.com/zgCgI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zgCgI.png" alt="enter image description here" /></a></p>
  <p>This is what RANDALPHA is from: <a href="https://yagisanatode.com/2018/08/23/google-sheets-random-alphabetic-random-alphanumeric-and-random-alphanumeric-character-custom-functions/" rel="nofollow noreferrer">https://yagisanatode.com/2018/08/23/google-sheets-random-alphabetic-random-alphanumeric-and-random-alphanumeric-character-custom-functions/</a></p>