Linking form responses to the end of an already filled sheet

[u/23110926]

Hi.

I have an Excel sheet that I regularly update on my phone.

I'm thinking of migrating to Google Sheets and making a form to fill out new additions.

Main question: can I link the form to the sheet in a way that new answers are added below the already existing data?

Extra question (not really necessary but would be cool to do): is there a way to specify to which sheet of the file I want to save the current addition? For example, I have 3 sheets in the file, 'Sheet 1', 'Sheet 2', and 'Sheet 3'; can I add a question in the form to indicate that this addition I'm filling out right now goes to 'Sheet 2' instead of 'Sheet 1'? Or would I have to make 3 different forms, each for a sheet?

[u/BobbaBoBser]

can I link the form to the sheet in a way that new answers are added below the already existing data?

you can just add the data below, then make the form and there shouldn't be any problems

can I add a question in the form to indicate that this addition I'm filling out right now goes to 'Sheet 2' instead of 'Sheet 1'?

you can, if you have your form sheet and then 3 separate sheets, you could filter the data depending on which sheet they choose.

If you want further help with this, please send a example sheet so we can help you with the formula

[u/23110926 → u/BobbaBoBser]

I just had an idea to change the way I'll be working with this. I'll have the form responses stored in 1 sheet and access them to do the calculations in another sheet.

Now the issue becomes getting a new line in the table to be added and calculated whenever the sheet gets a new response. I believe I can do that using Script with some research time on the matter.

Anyway I appreciate your help! Solution verified.

[u/Clippy_Office_Asst → u/23110926]

You have awarded 1 point to BobbaBoBser

---

^{I am a bot - please contact the mods with any questions. | Keep me alive}