I'm approaching SharePoint just now, i have this List with our actual and running projects, every project has a specific folder address on our server. I want to make that folder opening in file explorer everytime the user clicks on it. It works with pure HTML code using

<a href="file://\\server\folder\subfolder">LINK</a>

because of Internet Explorer having this function automatically enabled.

With SharePoint seems not working properly, maybe you can help me! Here is what i've done until now:

First example Second example

Do i have to use a particular extension or a specific format of the text? let me know.

1 Answer 1


You could make a

calculated column with the following formula:

CONCATENATE("<a href=""\\yourpath\",[Cartella Server],""">",[Cartella Server],"</a>")

if you have Italian regional settings you should use:

CONCATENA("<a href=""\\yourpath\";[Cartella Server];""">";],""">",[Cartella Server];"</a>")

Mind that the data type returned by the formula should be NUMBER

  • Where should i put that code :)? In the address field?
    – Kheg
    Apr 8, 2016 at 14:16
  • You should create a new Column for the link. You give it a name as usual but you choose calculated formula. In the formula you add the code and flag NUMBER as returned type.
    – Gyonder
    Apr 8, 2016 at 14:21
  • I get an error saying: One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas.
    – Kheg
    Apr 8, 2016 at 14:34
  • i've just put: CONCATENATE("<a href=""\\srvterm13v\PJ1400067",[Cartella Server],""">",[Cartella Server],"</a>")
    – Kheg
    Apr 8, 2016 at 14:35
  • The thing is that [Cartella Server] is a link column. It should be a text column. Is it a problem to make it a text column instead of a link column?
    – Gyonder
    Apr 8, 2016 at 14:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.