Google Forms output in Sheets combined with formula skips a cell

user_16358552 0
Viewed 77

So I have found the answer sort of already a couple of times, but not for my specific formula. I have a Google Form with checkboxes, but when multiple are checked the (long) answers are in CSV format.

I am using the formula:

=substitute('Form responses 1'!I2,",",char(10))

But when a new answer is inputted it goes from I2 to I4 while the output is in I3. I found both INDIRECT and ARRAYFORMULA as answers. But I cannot make my formula work correctly in the sheet.

Any help is appreciated. I tried for so long.

google-forms google-sheets
2 Answers

use in row 1:

={"header"; INDEX(SUBSTITUTE('Form responses 1'!I2:I, ",", CHAR(10)))}
user_56326290

Looks like it is working! I just had to change one thing:

={"AM"; INDEX(SUBSTITUTE('Form responses 1'!C2:C101, ",", CHAR(10)))}

I had to put an max to the cells. Thanks a lot!

user_163585520
Related