Sunday, May 27, 2012

yogi_Setup Computed Column Formulas For Quantities And Prices As Specified

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #567    May 27, 2012     www.energyefficientbuild.com.


I have posted the following solution to the problem based on a question by user AWark ...
http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/5hVt7a1FIY0


The formulas for computed columns need to be array formula in row1 of the computed column for the formulas to work correctly and get automatically populated as the submittals get logged in the Form responses sheet