SharePoint 2016 Site Owners

SharePoint 2016

Lesson 4 – Adding and Configuring Lists

invoice or billing list might calculate a bill based on hours entered in one column and billable rates from a column in a different list.

In a calculated column, you must select other columns that you will be performing the calculation on. In the following example, the formula states that for each item in the list, the value of the calculated column will equal the contents of the Test Hours column multiplied by the contents of the Test Passes column multiplied by 55 (which represents the billable rate of $55 per hour).

Figure 3.2 Calculated column

MSDN Examples of Calculated Column Formulas See this link for examples of and guidance for calculated field formulas: http://msdn.microsoft.com/en-us/library/bb862071.aspx

N EW C OLUMN C ONFIGURATION S ETTINGS When creating a new column, you can configure the following settings to define the type of content the column will contain, behaviors associated with the column, and other options.

CONFIGURATION SETTING

DESCRIPTION

Column Name

The name of the column as it will appear in the list.

The type of information in this column is

Provides options for the type of information stored in the column, as well as how the data might be entered or selected. A more detailed list of the types of columns is provided in the Types of Columns section of this lesson. The description you provide for the purpose and function of the Column

Description

OFFICEPRO, Inc.

Page 83