May 19, 2011

// // Leave a Comment

Calculated Column Condition in SharePoint


For creating a calculated column that is dependent on the other column which is in the same list , we can create in the browser itself. No need for the Sharepoint Designer.


STEP ONE:

Create a Column for Calculated List...

STEP TWO:

Identify the list which we have to lookup for calculation...

STEP THREE:

Syntax is

=IF([Column Name]="Condition one","Set this value one",IF([Column Name]="Condition Two","Set this value two"))

Like this we can add N conditions...

0 comments:

Post a Comment