I need a calculated column to display "Yes" if the current time is more than 3 hours after the value of another column. This is what I've come up with:


But SP tells me this is invalid. Are there other ways of doing this?


4 Answers 4


As you google around for this you are going to come across pages telling you you can do this with calculated columns using the [Today] trick.

You can't, it doesn't work and isn't updated dynamically - and even if it were [Today] doesn't include a time component so X hrs is out.

A couple of options for you


You may want to look at this, it's a good primer for calculated columns. Also, Today and Me are not allowed in calculated columns.


Excuse my self-promotion, but:

We've developed a custom column that can do just that, which is currently in Public Beta: http://www.pentalogic.net/sharepoint-products/highlighter/beta-testers-guide

To set it up to do this, you'd choose:

  • Highlighting
  • Display: Cell highlighting
  • Rules: Click "Add custom", then add the following two rules:

Rules example


This can likely be implemented not in a calculated column but in a computed column. The difference being that a calculated column is only calculated during edits, and a computed column for each render.


  • 1
    I'm curious as to how one would implement a custom Computed column at all, to be honest. I was under the impression you'd have to inherit from SPFieldComputed, which is uninheritable.
    – Stu Pegg
    Commented Apr 15, 2011 at 9:25
  • You don't develop a computed column, you only configure it. E.g. <Field Type="Computed"> and then use the render pattern to define the UI
    – Wouter
    Commented Apr 19, 2011 at 12:53
  • Oh, I understand. However, you don't have to use Computed in that instance, and I haven't come across a calculation-friendly version of ThreadStamp in the View Schema so far.
    – Stu Pegg
    Commented Apr 19, 2011 at 14:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.