Tuesday, 6 June 2017

IF ElseIF ELSE in Sharepoint Calculated Columns


Many times site admins struggle to put a login in SharePoint columns to put values based on IF-ElseIF-ELSE condition. For example, if a column A has three values like, High, Medium and Low, then the column 8 (calculated should have 1,2 or 3, based on column A).
The formula to use is

The logic is =IF([status]="High",1,IF([status]="Medium",2,IF([status]="Low",3)))

Where status is the column A. The detailed implementation is posted below:

I hope this will help you out.

Rahul Rashu

No comments:

Post a Comment