Question about SS Form populating 2 Sheets depending upon conditions.
I have created a form that will populate 1 of 2 sheets depending on the answer to the question on the form. It works exactly how it should. My issue is that when the form creates a new row on either sheet it is populating the majority of columns correctly. However there are 4 or 5 columns that are not populating, instead the form submission is creating new columns to the right of the last column on the sheet and populating those with the form data. How do I fix this issue?
Pre Form Submission
Post Form Submission - The new submission is the last row.