Integration with google sheets is not working

  • sebasromo
    Asked on June 28, 2016 at 5:51 PM

    Hi! I found an answer to my question but the image is not displayed https://www.jotform.com/answers/430834-Google-Spreadsheet-submissions-can-I-add-columns-and-rows

     

    The same thing is happpening. Every time a new line is added to the submissions sheet, in the processing sheet, where I have all my formulas, it jumps from =sheet1B4 to =sheet1B7 (if 7 lines where added due to the submission. 

    Do you have any clues on how to solve this?

    I need to copy and paste the formulas every time I want to update my results :(

    Thanks for the help.

  • David JotForm Support Manager
    Replied on June 28, 2016 at 6:12 PM

    The screenshot is showing now. So, please take a look a the thread again: https://www.jotform.com/answers/430834, and let us know if that helps.

    Another way to do this, would be by pulling data from the integrated spreadsheet to a new spreadsheet by using IMPORTRANGE, and then customize the new one as you want to.

    Let us know if you need more help, we will be glad to assist you.