SharePoint: Calculated Column Notes
A few misc. notes on SharePoint calculated columns. Calculated columns cannot reference Lookup columns. Samples of Calculated Field Formulas http://msdn.microsoft.com/en-us/library/bb862071.aspx Bottom line? Look for Excel style functions, not VB Script functions. For example, use FIND, not INSTR to find the position of one string inside of another.