Sunday, June 23, 2013

yogi-Create Multi-Condition Computed Column In 'Form Responses' Sheet

                                          Google Spreadsheet   Post  #1260
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun 23, 2013
user E Paul (http://productforums.google.com/forum/?zx=c8plvrplz67y#!category-topic/docs/spreadsheets/X5NgMOp--M4)
Formula and data from forms
So I created a form that feeds to my sheet - on the sheet I created a new column that contains a formula - the formula is a simple if/then statement that is supposed to change the color of that cell when data is entered into other cells (basically a status update).  I copied the formulate and that seems to work if I enter/change information on the sheet directly.  However, If I use the form to enter data it seems to just delete the formula.  

Any ideas?
----------------------------------------------------------------------------------------------------------