Welcome to Atlanta .NET Regular Guys Sign in | Join | Help

SharePoint 2007 - Calculated Fields

I was reading thru some blogs, namely that of Kevin DeRudder, today.  He recently posted some information on calculated fields.  I get questions pretty often from clients on the available formulas when creating a calculated field.  In his post, Kevin talks about how to reference a yes/no field from a formula inside a calculated field.

I just wanted to expand on his post a little and post this link to Examples of common formulas on the Microsoft Office Online site.  I frequently complain about the lack of documentation when it comes to SharePoint, but it seems someone had the time this time around and has documented a good deal of the formulas available for calculated fields.

Everything from Conditional Formulas, Date and time formulas, Math formulas, Text formulas and a few others are documented quite nicely.

There is even a page that talks about the Calculation operators.  This includes the "Types of operators" available and "The order in which a list performs operations in a formula".

I hope you find this page as useful as I did.

Published Monday, July 30, 2007 10:37 AM by Dan Attis
Filed Under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# re: SharePoint 2007 - Calculated Fields

I have looked for info on this forever now.  Who would of thought it would actually be on the microsoft site!  Thanks!!!
Thursday, October 04, 2007 1:43 PM by Kelly

# re: SharePoint 2007 - Calculated Fields

The only catch I've run into on those formulas is I can't find any for time conversion.  Several that reference string to time formats, which work well and easily.  But I need to switch something from Mil time to standard so that sharepoint calendars will recognize it.
Wednesday, December 05, 2007 12:32 PM by Jack

# advance remover spyware

Monday, August 11, 2008 10:39 AM by mayompela

What do you think?

(required) 
required 
(required)