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

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

You can see my spreadsheet at: https://docs.google.com/

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"),"

Thanks,

Brandon

-----------------------------------------------------------------------------------------------

following is my proposed solution to the problem