SharePoint 2016 Site Owners

Lesson 4 – Adding and Configuring Lists

SharePoint 2016

Figure 2-1: List and Library Settings page.

T ASK N OTIFICATIONS The Task list is a great tool to delegate and assign to do items to colleagues. However, by default the task list does not notify the assignee of their new tasks. They would need to routinely check the task list if they have been assigned a new task. This is not too practical. So a common setting site owners configure when they add a new task list the Email Notification from the Advanced Settings page. C OLUMN AND L IST V ALIDATION In SharePoint, you can validate that the data entered into a list or column is valid by specifying a column or list validation formula. The formula must evaluate as true in order for the item to be saved. The user will be prompted to correct errors if the column or list fails validation. The following table provides examples of validation formulas.

FORMULA

DESCRIPTION AND EXPLANATION

=IF(Len(TextCol)>8,TRUE,FALSE) Checks the length of the TextCol column to see if it is greater than 8 characters. If it is, the formula returns true,

and the column passes validation. If it is less than 8 characters, the formula returns false and the validation fails. Checks that the date in the FirstDate column is less than (earlier) than the current date by using the TODAY() function to return the current date. If FirstDate is less than (or earlier than) today's date, the column returns true; otherwise, it returns false.

=[FirstDate]<[TODAY()]

Page 78

OFFICEPRO, Inc.