EndUserSharePoint.com: How to create links, labels and coloring in a SharePoint list

I received a note from Christophe at Path to SharePoint about a few articles he has been working on. 

There are many people who want to be able to create HTML within a list cell in SharePoint. Using calculated columns to write HTML is a step-by-step process for doing that.

A second desire for many people is to have a hypertext link within a calculated column that does not show the link, just the label. The question comes up almost daily. Christophe use the Concatenate function to string everything together in How to Open Hypertext in a New Window (Or Not).

A third common question is how to color code cells within a list. Christophe uses another calculated column to add a “div” tag, controlling the color through “style” attribute. You can read about it in Applying color to your SharePoint lists.

Using the Calculated column with hardcoded stings and conditional statements does a lot more than people think. Thanks for the pointers, Christophe. Nice work.

For more information on the calculated column, you can follow the Taming the Elusive Calculated Column series by Dessie Lunsford, here at EndUserSharePoint.com.