title: Sort data in google sheets (with custom sort order) using google scripts
body: <p>As the title says, I need to sort my data depending on my first column which contains som rank names. I do not wan't it sorted alphabetically but rather in a order I define myself.</p>
  
  <p>Example:</p>
  
  <pre><code>Admin_contact
  Commissioner
  Battalion Chief
  Paramedic
  </code></pre>
  
  <p>I want them listed in that order using google scripts so it automatically sorts when data gets edited.</p>
  
  <p>Hope someone can help me achieve this</p>