Friday, October 5, 2012

yogi_Create A Computed Column In Form Responses Sheet To Conditionally Constitute an Email Address

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #792  Oct 05, 2012    www.energyefficientbuild.com.

user UCSCMatt said: (https://docs.google.com/spreadsheet/ccc?key=0AkHBcyclu11AdDJCdkM0eVZGNDV1aDVQeEhOMnE3cFE#gid=3)
Formulas and Conditional Formatting with Google Form Spreadsheets  

For example, I have a form that fills out columns A-W with data.  I want to create another column (Column X) that will display data based on what the form data says.  So that if a form user enters that their division is "Arts" for question 5 on the form, "Arts" get put into column F on the spreadsheet in the row representing that user's form response. I want my additional column (column X) to display a certain email address based on what Column F says.  I have a formula to do this that works in Microsoft Excel, but the google form spreadsheet seems to ignore it.

----------------------------------------------------------------------------------------------
following is a solution to the problem