Forum Discussion
Dynamic Hyperlink: open a document (with the same value as in the cell) in a folder via a cell value
With your full hyperlink text in cell A1, use this formula:
=HYPERLINK("file:"&A1, "Link anchor text goes here")
Thanks for your response!
I can't get it working yet.
I have tried this.
=HYPERLINK(H9&N3;TEXT)
In cell H9 is the selected article number, which is selected via a drop down menu. Just text, no links attached.
In cell N3 states the full hyperlink tekst to the sharepoint folder, in which are all the individual article files.
TEXT is the text which I have stated in K6, on which one need to click to go to the specific file.
Is there something I'm doing wrong?
Thanks in advance!
Nanno_S If the actual entire hyperlink ends with the article number, shouldn't the two cells be reversed in your formula?
=HYPERLINK("file:"&N3&H9;TEXT)Make sure the result of the first argument of that hyperlink function evaluates to a valid URL, preceded with "file:".
- JKPieterse
Thanks for the addition!
I have it working but not completely.
The file is being downloaded instead of opened in the browser.
What I have now is this:
=HYPERLINK("file:"&N3&H9&N1;"TEXT")
where:
N3= the link to the folder on Sharepoint
H9= 123456 (article number)
N1= .xlsx
TEXT= the text which I have stated in K6, on which one need to click to go to the specific file.
Do I need to add an action to open the file in the browser?
Thanks again.- Hmm, not sure. What happens if you remove the "file:"& bit?