I am able to add “External Links” to files manually using the drop down menu, but if I try the function =HYPERLINK(A1), where A1 = a url or a file path, I am not able to get a clickable hyperlink. It just shows up in blue font (sometimes) but doesn’t actually work. Is this a bug or am I doing something wrong?