In my case I wanted to have a hyperlink column in the Sharepoint 2013 pointing to a document in my fileSite.
e.g link: iwl:dms=DEV85SERVER&lib=LIVE&num=25210&ver=1
e.g link description: Document test
I tried to create a hyperlink column but SharePoint didn't recognize my DMS link.
So I had to create a calculated column to make the DMS link works.
- Create a column called "Document Link" as Single line of text.
- Create another column called "Document Description" as Single line of text.
Create a third column called "Link" as a calculated column.
3.1 insert the following formula:
=IF([Document Link]="","To be inserted","<a href='"&[Document Link]&"'>"&[Document Description]&"</a>")
3.2 Change the type returned from this formula to "Number"
Done!
This is just an example. I hope it helps.