PDA

View Full Version : SharePoint: Calculated Column Formula (Nesting Help)

richardlpalmer
06-19-2009, 09:34 PM
Running MOSS 2007 and have created a calculated column. I could use a hand coming up with a proper formula for it. There are 3 states the calculation needs to display (New, Refresh, <blank>). Here is what the formula needs to accomplish:

IF ORD >= TODAY, "New"
IF ORD < TODAY & NRD >= TODAY, "Refresh"
Else, ""

I know how to do a formula for one or the other IF/THEN/ELSE statements (see below), but don't know how to combine them.

=IF(ORD>=TODAY),"New",""
=IF(AND(ORD<TODAY,[NRD]>=TODAY),"Refresh","")
I've tried putting these together in various ways but so far no joy. This is what I've attempted to use but obviously don't have the syntax correct...

=IF(([ORD]>=[TODAY],"New"),(AND([ORD]<[TODAY],[NRD]>=[TODAY]),"Refresh"))

How should I write this better?

The second question I have is where can I find a good source on educating myself on this? So far I've found very good information on the functions supported by SharePoint (http://msdn.microsoft.com/en-us/library/bb862071.aspx)but they only explain what each of the Functions, Operators & Constants are. Nesting them is where I stumble. Assistance on this would be very appreciated.

richardlpalmer
06-22-2009, 06:35 PM
Anything?

richardlpalmer
06-22-2009, 09:21 PM
Well, if anyone's interested, here's the syntax for what I was looking for:

=IF([ORD]>=[TODAY],"New",(IF(AND([ORD]<[TODAY],[NRD]>=[TODAY]),"Refresh","")))
And I found this great resource of logical functions: http://office.microsoft.com/en-us/sharepointtechnology/CH101032621033.aspx

Basically, I just needed a 2nd "IF" function...