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.