I created a google forms linked to a spreadsheet called Submissions. The problem is that when files are submitted through the google form, they are automatically uploaded to the spreadsheet as a link that extends well beyond the cell borders.

I found a youtube video that said to make a second sheet and use the arrayformula function to be able to format the data from the first spreadsheet Submissions to look however I would like it to look. This works, however the files still come in as a url that extends well beyond the cell borders. I would like for every file in E through K (starting at row 2 all the way to row 50) to automatically be a file chip when it takes the data from the Submissions spreadsheet. Is there an apps script code for this? I do not know how to write any code, I am only going off of what I can find on youtube.

OR – is there an apps script code that I can use on the original spreadsheet that receives the submissions data to make all files into file chips so that I do not have to use a second sheet/arrayformula?

Second sheet with arrayfunction