Two forms, one sheet moving responses to new cells
I have one sheet with two forms. It's for employee onboarding. One form records some information from the employee and one form records information from the hiring manager. Two new rows are created in the sheet once the forms are complete. I'm trying to link those form responses to other cells within the same sheet (in a column called Inputs).
I did add two checkbox columns with an automation so that when Form 1 is complete the box is checked, when Form 2 is complete the box in another column is checked. I thought this may help me create the formula so that the data is collected from the correct row.
I'm lost on what formula to use. INDEX/COLLECT, INDEX/MATCH?
Help Article Resources
Check out the Formula Handbook template!