Multiple Spreadsheets - One for Each Answer

  • Profile Image
    vvance
    Asked on October 23, 2013 at 05:47 PM

    Is this possible? I have 4 options on the first part of my spreadsheet.

    opt1

    opt2

    opt3

    opt4

    Depending on which option was choosen, I want to combine the reply on different sheet.

    For example:

    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.

     

    Thanks,

    Vhiel

  • Profile Image
    Cesar
    Answered on October 23, 2013 at 06:15 PM

    Hello, 

    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.

  • Profile Image
    vvance
    Answered on October 24, 2013 at 10:08 AM
    Yes I want for each option to have a separate sheet on the same spreadsheet.
  • Profile Image
    KadeJM
    Answered 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.

    Example:

    =Sheet2!A2

     

    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.

     

    Resource: https://support.google.com/drive/answer/75943?hl=en