SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Sorry if my syntax is a bit off here, I'm very new to Sharepoint.

We have a document library in Sharepoint with a Managed Metadata column for the department (we have a list of departments in the Term Store library). The organisation has restructured recently, and we need to change the Department column to reflect the new department names. Each of the old department names does map to a new department name, but its not a 1:1 thing (for eg OldDept1 and OldDept2 may now both be NewDept1), so we need to do some kind of mapping procedure.

What would be the best way to go about this? We thought about adding a calculated column with a formula to do the mapping, but that won't stand up for future additions.

share|improve this question
up vote 2 down vote accepted

In this case I would recommend you to add the new department names to the manage metadata store and merge the old departments with the new values. You shoul check out the following blog post

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.