Lost your password?

Blogs about: Calculated Columns

Featured Blog

Quick Tip: Testing SharePoint Calculated Column Formulas

Marc wrote 4 months ago: I usually test my formulas in Excel. The syntax is the same; if it works in Excel, it’s going … more →

Tags: excel 2007, SharePoint

Auto-Group by Weeks (or Days, Months, Quarters, Years, etc)

Travis wrote 4 months ago: I wanted to make a calculated column that lets me automatically groups every list item created / mod … more →

Getting by the 7 If statement limit

Travis wrote 4 months ago: For anyone who has a complicated formula they need to do in SharePoint, I’m sure you’ve run into the … more →

Tags: Choose Function, IF statement

Customize Look And Feel With Calculated Columns1 comment

rharbridge wrote 7 months ago: Ever wanted to ‘Color Code’ a SharePoint calendar? Or have certain list items display differently th … more →

Tags: News and Opportunities, Reference, SharePoint 2007, Tips and Tricks, workaround, look and feel, tip and trick

Using calculated columns to write scripts12 comments

Christophe wrote 9 months ago: In the past 6 months, I have proposed many examples using calculated columns to write HTML. If you a … more →

Tags: SharePoint 2007, The HTML calculated column, Tips and Tricks

Issue: filters in calculated columns8 comments

Christophe wrote 10 months ago: I am about to release some scripts to improve the filter drop-down box for the “HTML calculate … more →

Tags: SharePoint 2007

Countdown with regional settings3 comments

Christophe wrote 11 months ago: Alexander Bautz has released a new version of his countdown, to take into account regional date form … more →

Tags: html/scripts, SharePoint 2007

Color coding: more examples72 comments

Christophe wrote 11 months ago: I already published an article about color coding for SharePoint lists three months ago, and its sib … more →

Tags: SharePoint 2007, The HTML calculated column

Sparklines and other charts in SharePoint lists12 comments

Christophe wrote 11 months ago: Look at the chart in the above picture. Isn’t that cute? Such little, text size graphics are c … more →

Tags: SharePoint 2007, The HTML calculated column

Live demo: holiday calendar9 comments

Christophe wrote 1 year ago: I got a couple questions about the holiday calendar displayed on my demo site, so here is the recipe … more →

Tags: SharePoint 2007, The HTML calculated column

SharePoint calendars: color coding, hover effects, etc.55 comments

Christophe wrote 1 year ago: Update [5/15/2009]: some readers have reported issues in specific cases (e.g. intraday events in cal … more →

Tags: html/scripts, SharePoint 2007, The HTML calculated column

Live demos3 comments

Christophe wrote 1 year ago: By popular demand, I have set up a public SharePoint site to showcase my customizations. This should … more →

Tags: Content Editor Web Part, html/scripts, Menus, Navigation, SharePoint 2007, Styles/CSS, The HTML calculated column, Tips and Tricks

Gantt view: a first test27 comments

Christophe wrote 1 year ago: This post shows a first attempt to use my “HTML calculated column” method to display Gan … more →

Tags: SharePoint 2007, The HTML calculated column, project management

Printable progress bars5 comments

Christophe wrote 1 year ago: You may have noticed that when you print lists including my examples of progress bars, the colors ar … more →

Tags: SharePoint 2007, The HTML calculated column

The "HTML calculated column": stay tuned!1 comment

Christophe wrote 1 year ago: If you are a SharePoint end user and haven’t heard about the “HTML calculated column … more →

Tags: SharePoint 2007, The HTML calculated column

Progress bar + color coding8 comments

Christophe wrote 1 year ago: This post is an answer to Owen’s question about progress bars: “How can I do conditional … more →

Tags: SharePoint 2007, The HTML calculated column

Calculated Column Dynamically Updated (When using [Today])1 comment

rharbridge wrote 1 year ago: Today I was asked a fairly common question that everyone who uses calculated columns eventually runs … more →

Tags: SharePoint 2007, workaround, FIX, Issue Resolution, Tips and Tricks, Today Field in a Calculated Column, Quick fix

Display forms and the HTML calculated column6 comments

Christophe wrote 1 year ago: Several readers have commented that the HTML calculated column works fine in the list view, but not … more →

Tags: SharePoint 2007, The HTML calculated column

Another example of progress bar5 comments

Christophe wrote 1 year ago: In the interest of sharing, Peter Allen from California has sent me his own implementation of the pr … more →

Tags: SharePoint 2007, The HTML calculated column


Have your say. Start a blog.

See our free features →

Related Tags
All →

Follow this tag via RSS