I have a google form where multiple students will anonymously submit comments/feedback for another peer.
Currently I am using the formula below to essentially concatenate all of the student comments specific to the individual receiving feedback.
=(join(" ",transpose(iferror(filter($L$3:$L, $C$3:$C=$C3,$B$3:$B=$B3)))))
- The line break within the "join" function is to separate the individual comments by a line break.
- Column L: The original comment submitted by the students.
- Column C: Filters by the name of the student being evaluated.
- Column B: Secondary filter criteria.
I am currently using the add-on "CopyDown" to apply said formula to each new submission. However, I notice that the newer submissions do not concatenate prior entries even though the filter conditions are met; the formula works correctly when I manually copy/paste it into the cell.
Is there a way to alter the original formula to dynamically update the cell contents as new submissions are incoming? Perhaps through arrayformula?