-
tom shipleyAsked on July 17, 2019 at 5:18 AM
How do i update it without losing my data
-
Victoria_KReplied on July 17, 2019 at 6:47 AM
From your question, I assume you have modified the integrated sheet and added your own calculations or data. Please note that we do not recommend to modify integrated spreadsheet or change its settings as this can cause the integration to fail.
Can you please re-integrate the form to google sheets? New integration should fetch all submissions fresh but you will get a totally new sheet file.
Here is related guide: How-to-Integrate-Forms-with-Google-Sheets
If you need to apply some changes to integrated sheet, I can suggest to use IMPORTRANGE function to copy the data from integrated sheet to different sheet and apply changes to that sheet keeping original one untouched.
Hope this helps.