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

Generate Auto number Field in SharePoint list

By -
Image
Generate Auto number Field in SharePoint list
To create auto generated list field do the following 1.Create a column field with data type number in the targeted list. For example I am creating an auto generated column Case ID.

2.Now to make the auto generated column hidden when a new item is created in the list we have to hide it in content types.
First go to list settings-> Then in General settings go to Advanced Settings


3.In Advanced settings Click the radio button Yes , in Allow management of content types .And Click OK.


4.Now go to list settings again and a new Content types will be shown. In that click the Content type. In my case it is Item. Name may vary for you.


5.In that Content type all list columns will be shown. In that click the Case ID Column.




6.After  that click the Hidden and then click OK
7.Then open SharePoint Designer create a new workflow for the list when a new item is created
8.And add update action to the list.
9.Click Add .In set this field value select Case ID
Read more