Saturday, November 24, 2012

yogi_Pull Data From Form Responses Sheet Into Sheet2 And Setup Two Computed Columns For Row By Row Sums Of C:D And D:E

                                          Google Spreadsheet   Post  #889

              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 24, 2012
user Ron01 said:(http://productforums.google.com/forum/?zx=jnm1y5sz2w47#!category-topic/docs/spreadsheets/iZ7I2Wi7ItQ)

how can i overcome the problem that a form delete my sheet formula on other columns then the form suppose to edit?

Hi,

I have this issue:
i created a form using spreadsheet.
in the form i have many rows and columns that i want to execute a function (formula) on,
after every row was submitted by the form.

in this scenario i have 2 issues i would like to solve:

1. after entering the 1t submitted form, i insert the formula, that i want to be duplicated to every new submitted form.
   the only option i saw i can do it is by copy the formula to X rows in advance manually.
   is there a way to make the formula copied automatically every time the form is submitted?

2. when i copy the formula manually down to empty rows, every time a form was submitted, it deletes the row before placing the data inside,
   so what it does is delete my copy formula, even that they are in cells that are out of the form range on that row.

Does any 1 know how can i overcome this issue, and make the form or the spreadsheet enter the correct formula without edit or delete it?
(i already try to make the calculation in sheet2 on sheet1 data... still have the same issue there).

Thanks.
Ron.
---------------------------------------------------------------------------------------------
in response to first question from Ron, following is a solution to the problem