yogi_Make Computations By Inserting Computed Columns Into A Form Responses Sheet

                                          Google Spreadsheet   Post  #1002

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 31, 2013

post by user: Brandon Fishman said:(http://productforums.google.com/forum/?zx=7oinkl81cee#!category-topic/docs/spreadsheets/UEBn0I5w5pM)
How to submit form, and keep formulas?
Hi I am trying to setup a form, that when it goes into my google spreadsheet formulas are applied to the data entered.  

You can see my spreadsheet at: https://docs.google.com/spreadsheet/ccc?key=0AnkVRC1UPDUGdFV4bU9fWnhaX0x3bmFuakZGMzlvN1E&usp=sharing

If you look at the Spreadsheet Columns A-D are populated when the form is submitted, then I want E to populate with NOW() to show the current time. 
In Column F I want a formula to subtract A and E to display How much time has lapsed since the form was submitted and the current time.  
In Column I I am using the formula =IF(AND(F2>2,H2="Open"),"Working",)
This is working fine if the data is entered into the spreadsheet, but when someone submits the form the fomula's are not applied to the new lines.  Any suggestions on how to get the formula's to apply to all form submissions?

Thanks,
Brandon
-----------------------------------------------------------------------------------------------
following is my proposed solution to the problem