B i t s O f S h a r e P o i n t C o n s u l t i n g L L C > T o p i c P o i n t > Calculated-Columns-Formula  

Web Part Page Title Bar image
T o p i c P o i n t

T o p i c P o i n t - A centralized place for topics with an Overview, related posts from BlogPoint, specific examples from ExamplePoint, and related internet resources.

 T o p i c P o i n t

O
HomeUse SHIFT+ENTER to open the menu (new window).
>
Calculated-Columns-FormulaUse SHIFT+ENTER to open the menu (new window).
>
Calculated-Columns-HTMLUse SHIFT+ENTER to open the menu (new window).
>
Document-LibraryUse SHIFT+ENTER to open the menu (new window).
>
Javascript-JQueryUse SHIFT+ENTER to open the menu (new window).
>
ListsUse SHIFT+ENTER to open the menu (new window).
>
Meeting-MinutesUse SHIFT+ENTER to open the menu (new window).
>
NavigationUse SHIFT+ENTER to open the menu (new window).
>
SharePoint-Add-onsUse SHIFT+ENTER to open the menu (new window).
>
WikiUse SHIFT+ENTER to open the menu (new window).

 ‭(Hidden)‬ docTip

 ‭(Hidden)‬ T o p i c P o i n t (select)

View All Site Content
Topic:Calculated Columns - Formula
 
The Calculated Column is great way to extend a list or data and to have many of the functions that Excel has. 
 
You will find links to the right that outline the basic functions that are available to use.  My Blog will show solutions that I have used.
 
To get started look at the links that start with MS, they will give a Microsoft document view of the formula and functions.
 
Calculated Column can also have HTML, look at my TopicPoint on this one to see what undocumented things you can do.
  Internet Resources - 1-Standard - Calculated Columns - Formula
MS - Examples of common formulas
 <div>Here you find common examples to the calculated column from MS.</div> 
MS - Formulas and Functions
 <div>Here is a list of the Formulas and Functions that can be used with SharePoint.</div> 

 Legend

1-Standard
Solutions that utilize the standard out-of-the-box features that come with WSS or MOSS.
2-Advance
Solutions that utilize Javascript/JQuery
3-Designer/3rd Party
Solutions that require SharePoint Designer or installing a 3rd party tool.

 ‭(Hidden)‬ TopicPointLinks

Title
Calculated Columns - Formula