Click select to navigate to the file I want to link to since it won't let me just select a folder. I just go to an empty cell, control-click and select HYPERLINK. I've found that I have to grant permission to the parent folder (in a roundabout way) that the files I'm trying to link to are in in order for my hyperlinks to work.
