Default Column Values
A SharePoint Online tutorial by Peter Kalmström
earlier SharePoint Online from Scratch articles Peter Kalmström, CEO
and Systems Designer of kalmstrom.com Business Solutions, has shown various
way to categorize SharePoint document library files with column values.
In the demo below Peter shows how to use default column values and discusses
the pros and cons with default values. Default values increases the risk of
wrong categorization, but on the other hand default values can help users
get started with categorization.
Peter also explains how you can work with tagging in an Excel like way in
the Quick Edit view, and he discusses if columns should require information
Set a default value for a column in a SharePoint document library
When a default value has been added, it can also be seen and changed in the
Library Settings, under General Settings, Column default value settings.
on the Library Settings button under the LIBRARY tab in the ribbon.
- Under Columns, click on the link to the column where you want to set
a default value.
- Under default value in the Edit Column dialog, enter or select
the value that should be default.
This looks a bit different in different column types. The image below is
taken from a text type column, where the default value should be written
or pasted in.
- Click OK.
Set a default calculated value of the current year
In the demo below Peter also shows a formula that calculates the current year
and adds it as a default value for a column.
This is the formula: =Text([TODAY],"yyyy")