Monday, November 26, 2012

yogi_TimeSheet Related Calculations In Computed Columns In Form Responses Sheet

                                          Google Spreadsheet   Post  #894

              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Nov 26, 2012
user Eddieb0s said:(!category-topic/docs/spreadsheets/BmCqesnFcGI)
Auto calculate a complex daily timesheet
I am developing a somewhat complex daily timesheet for my employees.  I have linked a copy of it here for anyone of you developers out there to help me with.

Everything works great!  Columns AT-BF automatically calculate the employees payout, HOWEVER, when a new form entry is added I have to copy those formulas to the next line because the form adds a new row!  It's quite tedius!  Is there a way that I can get the spreadsheet to automatically pull the formulas down when a new form is submitted?
there are a number of redundant columns in this spreadsheet -- however I have made no attempt to reduce the number of columns; I have marked the computed columns with light brown background color and I have shown the formula that needs to be used for each of the computed columns -- ideallt the formula for the computed column should be written in row 1 so that the formulas are aploicable from Get Go.