Calculated Column Condition in SharePoint

By -

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

Popular posts from this blog

How to copy SharePoint list workflow

By -
Image
We often face a situation where we need to copy a big workflow from list or library to another list or library. This situation can be avoided if we have created the workflow as reusable workflow. So in this article I will explain in simple steps on how to copy a list workflow to another workflow using SharePoint designer. Using this method we can copy workflow across site collections are web applications.

For this we have the following List Name Workflow Name List 1 List Workflow 1 List 2 List Workflow 2 (Copied from the worlflow1)
Step 1) We have the list 1 with list workflow 1 to be copied to list workflow 2.
Step 2) Now create a list workflow 2 , in list 2 with one condition plus once activity and save it. In our example I have used a condition and sending email to current user. This is used to create the Xoml rules for the list workflow 2

Step 3) Now in the side of navigation click All Files

Step 4) In all files click the Workflows

Step 5) Open the List workflow 1 and also repeat t…
Read more

INFOPATH FORM HIDE/DISABLE FIELDS BASED ON SHAREPOINT GROUP MEMBERSHIP

By -
Image
Hi guys in this tutorial you will get to know how to identify whether a user is part of a Share point group in InfoPath form.

NOTE:
This will work only for WINDOWS AUTHENTICATED SP sites
In this example we will use the logged in persons user name is in IT SP group. If he is in the IT SP group we will enable Submit Button and If he is not in the IT SP group we will enable Submit to IT button.
STEP 1:
Go to the SP site. Go to People and groups and create a group IT. And Add users to the group.





Added test user 1 in the SP group.


STEP 2:
Open the InfoPath 2010.

Created 3 fields Name, Emp ID, Department and 2 Buttons Submit to IT and Submit


STEP 3:
Go to the Data tab and select Data Connections





Add a Data Connection






















Read more

Create multiple columns inside SharePoint List using Powershell

By -
Image
Hi All,

1) In this post we will be seeing how to add multiple columns inside SharePoint List/Library and adding to the view

2) Refer the below posts in the powershell series.


 Bulk Creation of Site Columns: http://www.sharepointbasic.com/2016/11/powershell-script-to-create-bulk-site_27.html
Bulk Creation of Site Content Types:    http://www.sharepointbasic.com/2016/12/powershell-script-to-create-bulk-site.html
Bulk Lists and Libraries in SharePoint http://www.sharepointbasic.com/2016/12/powershell-script-to-create-bulk-lists.html
Bulk File upload to sharepoint library http://www.sharepointbasic.com/2016/12/upload-multiplebulk-files-to-sharepoint.html
3) Create a CSV File like below



4) Use the below Powershell script


#This script creates site columns from the given csv file#Author: Prem Kumar#Date: Feb 11 2015param( [string]$rooturl = $(Read-Host -prompt "Enter Web Application Root URL...?"), [string]$listname = $(Read-Host -prompt "Enter the list name...?"), [string]$csvpath …
Read more