Cell Linking Default in New Rows


I have a sheet with hyperlinks to training documents. I have another sheet which tracks when the training is completed for each person. I'm currently cell linking the training document to the other sheet but I need that cell link to be the default value when a new row is added. I tried VLOOKUP but only text appears and no hyperlink. Having the URL as a default in the Form also wouldn't work as it would require too much upkeep when the documents are updated. I have the other sheet so people can see all the documents at once and update the URLs quickly.

Thanks in advance,


Best Answer