- vvanceAsked on October 23, 2013 at 05:47 PM
Is this possible? I have 4 options on the first part of my spreadsheet.
Depending on which option was choosen, I want to combine the reply on different sheet.
Opt1 reply - Sheet 1
Opt2 - Sheet 2
Opt3 - Sheet 3
Opt4 - Sheet 4
All in all my worksheet will have 4 sheets once I integrate them with Google docs.
- CesarAnswered on October 23, 2013 at 06:15 PM
Just to make sure, you want for user to submit the form, when the form is submitted you need for each option on the form to be listed on a different sheet of the spreadsheet.
Do let us know if this is what you would like to achieve. Thank you.
- vvanceAnswered on October 24, 2013 at 10:08 AMYes I want for each option to have a separate sheet on the same spreadsheet.
- KadeJMAnswered on October 24, 2013 at 11:32 AM
Okay, Thank You for clarifying and confirming that. You are basically seeking this:
Unfortunately I don't know of us having a feature to meet this demand just yet. So the only way I can imagine this might work right now is by using " Reference Commands " within your Google Spreadsheet itself which will send the Data to other Page Groups on your Main Spreadsheet.
I believe it would look something like this using a Test Group of 3 Radio Buttons to transfer to Sheet2 on the spreadsheet in the Formula.
I was able to get the data to be sent to a different Page. However, I have a limited knowledge on the use of SpreadSheet Formulas so I was having a little bit of trouble getting it to receive into the other SpreadSheet. I think this should work but it is not working for me at the moment. It may take a little bit more time but I will let you know once I know more about this.