Showing posts with label Calculated Column. Show all posts
Showing posts with label Calculated Column. Show all posts

Monday, July 4, 2016

Calculated column Split in SharePoint list

For Example
Create Calculated column called "EMP-01" and type in this formula

=LEFT([ID],INT(FIND("-",[ID])-1))
Result :
EMP
Create Calculated column called "Employee ID" and type in this formula


=RIGHT([ID],LEN([ID])-INT(FIND("@",[ID])))

Result:

01

Thursday, June 9, 2016

How to use Today and Me in Calculated column



[Me] in de View Filter settings

Thursday, May 5, 2016

How to display only day and month in SharePoint list column?

We will create the Calculate Column
Example for Month

=TEXT([columname],"MM")

Example for Year

=TEXT([columname],"YYYY")
Example for Date
=TEXT([columname],"DD") 

Tuesday, March 15, 2016

calculate the number of the week based on a date in a list?

Week starts on monday. Depending on your regional settings you have to replace the ; with ,

Example:

=IF(INT((StartDate-DATE(YEAR(StartDate);1;1)+(TEXT(WEEKDAY(DATE(YEAR(StartDate);1;1)-1);"d")))/7)=0;52;INT((StartDate-DATE(YEAR(StartDate);1;1)+(TEXT(WEEKDAY(DATE(YEAR(StartDate);1;1)-1);"d")))/7))


Example:

=INT(([Start Date]-DATE(YEAR([Start Date]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Start Date]),1,1)),”d”)))/7)+1

Saturday, October 17, 2015

How to calculated column in SharePoint Date field?

=TEXT([Date],"mm")   =>       date is 1-Jun-2015

Result:
06
=TEXT([Date],"mmmm")  =>    date is 1-Jun-2015
Result:
January

=TEXT([Date],"mmm")   =>    date is 1-Jun-2015

Result:
Jan

=TEXT([Date],"yyyy")   =>    date is 1-Jun-2015

Result:

2015


=TEXT([Date],"dd")   =>    date is 1-Jun-2015

Result:

01