How to edit submissions through a google sheet

  • Profile Image
    Asked on November 21, 2017 at 05:01 PM


    I had emailed JotForm Support earlier about how to edit submissions on the google sheet and was told that I could import the data to a new sheet, creating a copy and then edit it however using IMPORTRANGE only creates a read - only version of the sheet. Is there any other suggestions on how to edit information on google sheets.

    Thank you,

    Diane Sarria

  • Profile Image
    Answered on November 21, 2017 at 07:19 PM

    Please note that the importrange function will create an exact copy of the original sheet, you are able to edit it as long as you're the sheet's owner or you have allowed access to do so. 

    Please make sure that you're logged into your correct Google account while working on the sheet.