Customize Look And Feel With Calculated Columns
Ever wanted to ‘Color Code’ a SharePoint calendar? Or have certain list items display differently then other list items based on their column values?
One of those things that every user needs is the ability to customize the look and feel of many SharePoint elements, and sometimes it just doesn’t make sense to wait for a SharePoint team, developers, or architects to work out a long term solution.
Sometimes you just need a quick and dirty way of doing something as a one off to illustrate a point or to deal with a situation while you work out the full solution.
The concept is simple:
The power of this is that it can apply to a great many different scenarios. Take for example one of the common requirements of ‘color coding’ a calendar. In Christopher’s post last november he cleverly illustrates exactly how you could do this with relatively little effort: http://pathtosharepoint.wordpress.com/2008/11/15/sharepoint-calendars-color-coding-hover-effects-etc/
This is a simple and effective way to deal with many look and feel issues quickly and easily. If used with a bit of direction this can really help users understand, consume, and review information much more quickly.
(Above image from another example of how it can be used: http://pathtosharepoint.wordpress.com/2008/09/01/apply-color-coding-to-your-sharepoint-lists/)
Update: Adorable little calculated column builder (based on what I describe in this post) – http://www.pathtosharepoint.com/HTMLcc/default.aspx. Could save you a bit of time.
Hopefully with a glance at some of these you can begin to see the usefulness and power such a method can provide for your SharePoint deployment, I know I use it fairly often and I am sure you will too,