Default Column Values
A SharePoint Online tutorial by Peter Kalmström In earlier 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 or not.
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.
- Open the Library settings.
- 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")