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