The data from Jotform that is sent to my own spreadsheet is changing my formulas

  • Profile Image
    Asked on June 22, 2015 at 02:27 AM

    i am useing google sheets for my data from jot form and have my own spread sheets that i need to transfer the data to in the same doc as the doc set up when i linked it. in my sheets i have made there is some formulas that take the data from the submission page. each time the data comes in from jot form it is changing my formulas that the line of data is linked to and moving the formulas down a line. how do you stop this?! i useing your form as it links to google sheets well and i have my spread sheets in google sheets and it can input the data for me!

  • Profile Image
    Answered on June 22, 2015 at 06:01 AM

    Are you using the IMPORTRANGE function in Google Spreadsheet to pass the data from the form's spreadsheet to your own sheet? I don't have the idea yet on how to stop the problem from happening, but if you can share us the spreadsheets, we would be happy to check it further for you.

    But maybe, you should check the formula and see if there is something that overrides the functions making it move down a line.