title: Protect formulas from shared users
body: <p>I've created a shared Google Docs spreadsheet with many sheets.  On most all of the sheets columns F:H contain formulas that manipulate the data entered in other columns.   I want users to enter data in the non-formula columns and be able to add more rows when they need to.  </p>
  
  <ul>
  <li>I've tried protecting the columns - but then users are unable to insert rows.</li>
  <li>I've tried creating a script that offers a menu to add rows - but then the users are told "You are trying to edit a protected cell or object. Please contact the spreadsheet owner to remove protection if you need to edit."</li>
  </ul>
  
  <p>This would seem like a very simple need, protect formulas and allows users to insert rows. (Hopefully the formulas would be copied, but if not I could copy them in a script.) </p>
  
  <p>Anyone have any ideas?</p>