Does hiding a column in a Google Spreadsheet break the integration?

  • Profile Image
    cumis
    Asked on June 12, 2013 at 07:20 PM

    I'd like to produce a spreadsheet with only parts of the information listed on the form.  This way I can have one less bulky spreadsheet with just contact/essential information.  The rest of the information is better viewed for my process in the PDF file that is synced to my Google Drive.  I've tried hiding columns in the spreadsheet, but it seems to break the integration and new entries no longer automatically populate the spreadsheet (though their PDF submission comes through to Google docs).  Any remedy or workaround for this?

     

    Thanks for the help!

  • Profile Image
    EltonCris
    Answered on June 12, 2013 at 10:05 PM

    Hi there,

    Instead of modifying the main sheet, I would suggest to create a subsheet instead and get all the desired data from the main sheet by using excel formula. Example, you can use the following formula.

    =Submissions!A1

    This formula copies all the data under Column A to the subsheet. If you'd like to copy Column B, simply change the "A" in it.



    Hope this helps. Thanks!