Forum Discussion
Dynamic Hyperlink: open a document (with the same value as in the cell) in a folder via a cell value
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?
No, difference.
I have tried multiple options to see if something works.
I even took parts of the URL and add different kind of texts to it including the article number forcing the URL to open the file.
What I notice is that the URL to, only, the folder is different then the URL part to the folder in the complete file URL.
And the last part of the file URL is "&action=default&mobileredirect=true". So, I have added this to the URL in my link as well. But this does not work either.
What I want is a challenging one, I think.