While it’s possible to set default values for SharePoint columns at library level at field settings, What if you want to set the default column value of a document based on the folders it’s saved? SharePoint Server / SharePoint Online provides a new feature to set metadata values based on the location!
How to Set Default Metadata from Document Location?
Say, We have a document library with “Department” column and with few folders namely “Sales”, “Marketing”, “IT”, etc. as in this screen.
And we want the metadata field “Department” value based on the location.
Set Column Default Value Settings in SharePoint
- Go to the List / Library >> Click on Settings >> List settings. In the list settings page, select “Column default value settings “.
- Click on the desired metadata column link of the respective folder(s)
- and set the value for it
When users upload a new document to different folders, the “Department” field gets value from this setting automatically. This doesn’t change the metadata on all existing documents, BTW!