-
sebasromoAsked 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 ManagerReplied 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.