Google Spreadsheet Integration: How to make sure the data in Sheet 1 will be passed without interruption in Sheet 2 after a successful form submission

I have a situation with the integration
of responses with google spreadsheets. Not sure if it is possible to share
the screen with you?
In words, I have 3 tabs on google sheets:
1. responses from jotform
2. a mapping of sheet 1 with calculations (connected with sheet 1)
3. summary (connected with sheet 2)
Problem: when a new response data is added in sheet 1, the formula in sheet
2 is completely wiped out. and therefore the data does not transfer. And
therefore, the data in sheet 2 does not appear in the summary sheet 3.
If that makes sense...
If you have a solution, please let me know! I have been spending hours on
this - thank you very much in advance!

First, I just would like to inform you that you can share a screenshot in the support forum following the instruction in this guide: How-to-include-screenshot-image-in-the-support-forum

With regards to your concern, I understand that you are trying to have the data in Sheet 1 appear in Sheet 2. However, the issue you are having is that when a new submission comes in, the formula in sheet 2 disappears.

I see that you are working with this form (http://www.jotformeu.com/form/71291751254354). We will be glad to help you with your concern. Would it be possible for your to share with us the link to your spreadsheet? We would also like to make test submissions directly to your form if you will allow us.

We will wait for your response. 

Thank you.

Hello,
Thank you very much for your support! Very nice of you - however, I have
already figured it out!
Have a great weekend (:
Jovana
Jovana Sanussi
Ihr Fuhrpark 4.0 | Avrios International AG
T +41 79 453 61 01
W avrios.com
B blog.avrios.com
Besuchen Sie uns auf @getavrios


...