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...
Comments
Post a Comment