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