title: Google spreadsheet: Copy one row to a different Tab after inputting the word "Done"
body: <p>I am trying to copy one row to another tab within the same Google Spreadsheet after I write the word "Done" in the first tab in column J. Any ideas?</p>
  
  <p>I tried doing this myself using ImportRange but can't seem to get the formula correct. If it's not an importrange, please let me know what other formula would be correct for this purpose. </p>
  
  <p>Here is the spreadsheet (feel free to edit):
  <a href="https://docs.google.com/spreadsheets/d/1d8wNc7XDcMfGomVkZPzBcE1Vz1YmCYMp_0mpyzDEQp4/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1d8wNc7XDcMfGomVkZPzBcE1Vz1YmCYMp_0mpyzDEQp4/edit#gid=0</a></p>
  
  <p>Please note, I am not looking for a script. Any ideas and suggestions would be very much appreciated.</p>
  
  <p>Thanks a ton!</p>