The capabilities of SharePoint regarding column and view formatting can enhance the usability of both SharePoint libraries and list. In this blog the explanation using a lookup column and the challenging part regarding the use of special characters. Scenario The SharePoint list has a lookup column to a document library, so a link between the list item and associated document can be made. At first glance, this looked fine: However when you clicked on the file link, the file didn’t open, but ...