title: Want to auto sort a Google sheets spreadsheet on edit, but want to sort by date
body: <p>Been looking around for a solution to this for a while and not finding anything that works, unfortunately.  I have tried copying and pasting several bits of code but cannot get my sales pipeline sheet to automatically sort on edit of a date field.</p>
  
  <p>The link below is to a test sheet which should give an idea as to how I have formatted my sheet:</p>
  
  <p><a href="https://docs.google.com/a/trinitymirror.com/spreadsheets/d/1huTvgwfmh0RM0kz4BUEuYFZm7DwBG-69D8jTfps3IPg/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/a/trinitymirror.com/spreadsheets/d/1huTvgwfmh0RM0kz4BUEuYFZm7DwBG-69D8jTfps3IPg/edit?usp=sharing</a></p>
  
  <p>I want to sort by Column G with the most recent dates at the bottom of the sheet.</p>
  
  <p>Any suggestions welcome! </p>
  
  <p>Thank you in advance for your help.</p>