Hi,
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.
Thanks,
Rahul Rashu
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.
Thanks,
Rahul Rashu
No comments:
Post a Comment