Advertisement

Responsive Advertisement

How to create Calculated Fields in SharePoint 2013

  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.

 Examples:

"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

Post a Comment

0 Comments