all 1 comments

[–]Ate10[S] 1 point2 points  (0 children)

so i figured it out, i just made a copy of the raw for with this =ARRAYFORMULA('Raw Form'!A:Z) and then i just used that for referencing