Wednesday, 27 April 2016

SharePoint: How do I create a link as a calculated column.

The 'secret' is to set the column type to NUMBER and then create a concatenated string of the anchor. For example, this would be a link to to my side passing in the ID of 1 to the query string

The formula could look as follows:
=CONCATENATE("<a"," href='","http://richardtestsite?ID=",[ID],"'>click here</a>")

No comments:

Post a comment