I started this blog one year ago, and one of the first techniques I shared was the “HTML Calculated Column”.
I’ve talked about many other topics since then, but to date the “HTML Calculated Column” remains by far the most popular. The original post has been viewed more than 45,000 times, while its little sister explaining how to use the technique for color coding has been viewed 27,000 times.
Online workshops coming soon
In the past year, I have refined this technique and published more tutorials. I have also created a formula generator to handle simple cases. The latest version of the script is on this same page (under the Download tab).
The “HTML Calculated Column” technique has also been relayed by many SharePoint bloggers. On EndUserSharePoint.com for example, you’ll find Paul Grenier’s jQuery version of the script, and a detailed example by Jim Bob Howard: the payroll schedule.
However it was still not enough to answer all the users’ requests. So I worked with Mark Miller to set up two online workshops that will include this topic.
The first one in October actually focuses on calendars, color coding being one of the featured solutions.
The second one, in November, will be dedicated to the HTML Calculated Column. During the workshop, I’ll answer your questions and we’ll work on your specific use cases.
To be informed of upcoming workshops offered by EndUserSharePoint.com, you can check out this page or subscribe to the RSS feed.
Congratulations on the success of the Path to SharePoint blog. From what I’ve seen around the SharePoint community you’ve hit on something lots of SharePoint users needed.
Keep up the good work!
nice info……thanks yaa. plizz reply me dont forget……….
As always your stuff is wonderful. I am looking to enahnce this slightly but I am having issues with my code. What I am trying to do is allow Sharepoint to auto-update my status color based on the date. For example we have reports that are reviewed at specfic time and users are given 2 weeks to respond. I would like it to display GREEN if Due Date is == Today -14, Yellow if Due Date is Between Day 8-13. is that even possible??
Ken: for ideas on how to deal with “Today”, search for “countdown”on my blog.
Is there any way to get this to work with datasheet views? It seems to break and just show the code whenever I try a datasheet view.
The datasheet view is not html, and the script has no effect on it.
I would love to see a calculated column based on percentage of time elasped between to dates. I can’t find any thing that is dynamic.
Do you mean a calculation that takes into account today’s date? This is not easy to do with calculated columns.
You can search for countdowns in my blog, this will give you a couple ideas to get started.
Have you find a way to make the filter drop down menu items be displayed as HTML??
Working on it: