How to create Calculated Fields in SharePoint List


Calculated Field

                   Using calculated columns we can automatically generating data, adding days to a date column to calculate an expired or due date column, Number or Currency columns to get a total…

        In list, I want to create field “SP2013”, in 2013 I want to show year (yyyy). Now we are going to create calculated field for SP2013.  Navigate to list settings in any custom list, click on create column. Type your Column Name “Year” and select “Calculated” column and type  formula  “"SP"& (TEXT([Created],”yyyy”))” as shown in fig below.

Some Date and Time Formulas

"SP"& (TEXT([Created],”mmmm dd, yyyy”))                                                      October 17,2012

"SP"& (TEXT([Created],”yy”))                                                                                     SP13

"SP"& (TEXT([DateTimeField],”hh:mm:ss”))                                                           SP12:00:05

"SP"& (TEXT([Created],”dddd”))                                                                               SPWednesday

"SP"& (TEXT([Created],”mmmm”))                                                                              SPOctober

In my Article we can check to create Calculated Fields in SharePoint List Schema.


Lakshmi Tulasi Jasti

  • Image
  • Image
  • Image
  • Image
  • Image
    Blogger Comment
    Facebook Comment


Post a Comment