title: Need help recording from dropdown list in google sheets
body: <p>I have a dropdown menu on google sheets and want to record every time there is something chosen from the list or changed into a &quot;recording&quot; column.</p>
  <p>Example,</p>
  <p>Dropdown(Cell A2) options are red, green, blue, pink,</p>
  <p>I want the column to record every time someone changes the option.</p>
  <p>RESULTS (column B2) every next available cell</p>
  <p>red</p>
  <p>green</p>
  <p>green</p>
  <p>blue</p>
  <p>green</p>
  <p>blue</p>
  <p>Here is the example in google sheets
  <a href="https://docs.google.com/spreadsheets/d/1qqxCBBg0UgNV6EItEb3FfzcfDdtQ-v2QEMjWfiWw/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1qqxCBBg0UgNV6EItEb3FfzcfDdtQ-v2QEMjWfiWw/edit?usp=sharing</a></p>
  <p>I was told I need use the app script with this
  =INDIRECT(&quot;A1&quot;)
  Open the script editor, and type this function.</p>
  <p>`
  function archivesFun(){
  const ss = SpreadsheetApp.getActiveSpreadsheet();</p>
  <p>const sheet = ss.getSheetByName('archive');</p>
  <p>const data = sheet</p>
  <p>.getRange(1,2)</p>
  <p>.getValue();</p>
  <p>sheet.appendRow([data]);
  }`</p>
  <p>I am just completely new to coding, any help is appreciated!</p>