How to delete old column from Google Sheets integration?

  • Profile Image
    noonmoontea
    Asked on April 14, 2018 at 01:15 AM

    I got rid of a text input in the form but it's still showing as a column in Google Sheets and I want to get rid of it. I don't want to break the integration. Is there anyway to remove it without having to create a new link?

  • Profile Image
    Vanessa_T
    Answered on April 14, 2018 at 09:11 AM

    Once a new submission will be received, your google sheet should update automatically and remove the column of your recently deleted form field.

  • Profile Image
    Adrian
    Answered on April 14, 2018 at 12:22 PM

    The Integrated Google Spreadsheet will not automatically remove (update) the column of the field that you have deleted.

    You can manually remove the Column by right-clicking it and then selecting Delete Column.

    15237227711.png

    However, I cannot guarantee that the integration will work again. I have tested this in a demo form and the integration was working after deleting the column that I have deleted in the form.

    If you need to make changes to the form, I suggest you try using the IMPORTRANGE function in another Google Spreadsheet and make the edits in that sheet.

    https://support.google.com/docs/answer/3093340?hl=en