SharePoint 2016 Site Owners

SharePoint 2016

Lesson 4 – Adding and Configuring Lists

7) Add custom Number columns in a custom list. a) Scroll down to Columns . b) Under Columns, click Create Column . c) Under Column name, type Job Knowledge .

d) Unser The type of information in this column in , select Number (1, 1.0, 100) . e) Unser Description , type 1 = Poor; 2 = Fair; 3 = Satisfactory; 4 = Good; 5 = Excellent . f) Under Require that this column contains information , select Yes . g) Under You can specify a minimum and maximum allowed values , in Min type 1 , in Max type 5 . h) Under Number of decimal places , select 0 . i) Click OK . j) Repeat steps a through i to add a Work Quality , Attendance/Punctuality , Initiative , Communication/Listening Skills , Dependability columns. 8) Add custom calculated columns in a custom list. a) Scroll down to Columns . b) Under Columns, click Create Column . c) Under Column name, type Overall Rating . d) Unser The type of information in this column in , select Calculated (calculation based on other columns) . e) Under Formula, type =average( f) Under Insert Column, double-click Job Knowledge g) Click at the end of the formula and type , h) Under Insert Column, double-click Work Quality i) Click at the end of the formula and type , j) Under Insert Column, double-click Attendance/Punctuality k) Click at the end of the formula and type , l) Under Insert Column, double-click Initiative m) Click at the end of the formula and type , n) Under Insert Column, double-click Communication/Listening Skills o) Click at the end of the formula and type , p) Under Insert Column, double-click Dependability q) Click at the end of the formula and type ) r) Under The data type returned from this formula is , select Number (1, 1.0, 100) . s) Under Number of decimal places , select 2 . t) Click OK .

7) Re-order columns.

a) Scroll down to Columns . b) Under Columns, click Column ordering . c) Change the Position from Top for Comments to 13 . d) Click OK .

8) Test custom list. a) In the Quick Launch, click Yearly Employee Performance Review . b) Click the +new item button. c) Enter the following information:

OFFICEPRO, Inc.

Page 91