SharePoint 2010 Calculated Hyper Links

Normally if I wanted to use a hyperlink column in SharePoint I would create a workflow that sets the URL then shortens the description. Like this:

There is a much better way....

Create 2 single line of text columns one title URL another titled URL Description.
Create a third calculated column with this formula:

="<a href='"&URL&"'>"&[URL Description]&"</a>"

Set the data type to Number.




The result is a pretty hyperlink


Ping Back: https://devdotnotes.wordpress.com/2012/01/29/sharepoint-caculated-column-and-hyperlink-no-workflow-or-script-needed/