When Google Forms collects responses, it creates an entirely new row in the Google Sheet which I don't want to happen because I am using a VLOOKUP for another sheet and it's not grabbing the data I want. Ideally, when a response is collected, I don't want it to create a new row but to be in the same row I have created so the vlookup function would work. Any ideas?
Google-sheets – How to disable new row when Google Form collects responses for Google Sheet
formulasgoogle sheetsgoogle-formsgoogle-sheets-query
Related Topic
- Google Forms – Simplify Checkbox Responses into Itemized List
- Google-sheets – How to get new Google Form responses to take on non-form functions in Google Sheets
- Google-sheets – Google Forms to spreadsheet edit responses and new responses on the top
- Google-sheets – How to select existing sheet to be populated by a Google form
- Google Sheets – Fix Google Form Deleting Rows in Second Sheet
- Google-sheets – Why doesn’t google forms recognize responses manually added to the responses sheet
- Google Sheets – Issues with Google Script Collecting Form Responses
- Google Sheets – How to Automatically Match Text Responses to Numbers and Sum
Best Answer
You can (should) use
QUERYformula to recollect all your data in your desired format/output and then mine this createdQUERYwith yourVLOOKUPformula. Syntax example: