title: Google Spreadsheets: Working with data inserted from forms across tabs
body: <p>I'm in great need of help. I've a form which asks basic questions and puts the results into rows of an existing spreadsheet.</p>
  
  <p>Specific data from those responses are "promoted" to 2nd, 3rd and 4th tabs based on IF formulas on tabs 2+ checking the value of a pull down selection on in the corresponding row on each previous tab. (Waterfall)</p>
  
  <p>My challenge is - forms data is inserted into a new row (Does not use existing) and if I set the pulldown value to "Approved" on the first tab, the formulas on the second tab which were contiguous now skip the row where the form data was automatically entered.</p>
  
  <p>I suspect I need to learn how to properly use ArrayFormula, etc, but have not managed to fix this looking at existing examples combined with my IF statements.</p>
  
  <p>Help is appreciated. <a href="https://docs.google.com/spreadsheet/ccc?key=0AvnKlegx7T5bdHZjU1dSVjhFalEzMmtzZUhrVXdiYUE&amp;usp=sharing" rel="nofollow">Sample is here.</a> Safe to ignore the first and last tabs.</p>
  
  <p>Thank you.</p>