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.
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?
----------------------------------------------------------------------------------------------------------
No comments:
Post a Comment