title: Sort Google Spreadsheet With Multiple Criteria Using Script
body: <p>I have a spreadsheet that I update on a regular basis. I also have to re-sort the spreadsheet when finished because of the changes made. I need to sort with multiple criteria like the below settings. I have searched for examples but my Google search skills have failed me.</p>
  
  <pre><code>Sort range from A1:E59
  [x] Data has header rows
  sort by "Priority" A &gt; Z
  then by "Open" Z &gt; A
  then by "Project" A &gt; Z
  </code></pre>