I am struggling with an automatically updating spreadsheet that is connected to a Google Form.
Whenever there is a new accomplished answer in the Form it is adding a row in the spreadsheet, resulting in a shifting of my whole spreadsheet.
Take a look at the picture to understand the problem:
As you can see, the row is created and shifts everything apart. Is there a way, to prevent that, like protecting the area from K-P ("Preis pp." the gray-colored one until the end)?