SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


share|improve this question
up vote 4 down vote accepted

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

share|improve this answer

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.

share|improve this answer
Handy link, I've included it in the tag wiki (to be approved): – Stuart Pegg Apr 15 '11 at 9:50

Excuse my self-promotion, but:

We've developed a custom column that can do just that, which is currently in Public Beta:

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

share|improve this answer

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.


share|improve this answer
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. – Stuart Pegg Apr 15 '11 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 - SharePoint MVP Apr 19 '11 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. – Stuart Pegg Apr 19 '11 at 14:01

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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