We have our SharePoint sites in the following tree structure:
Corporate +--- Division A +--- Department 1 +--- Department 2 +--- Department 3 +--- Division B +--- Department 1 +--- Department 2 +--- Department 3
I have a number of metadata columns that are defined at the
Division A level because they're used across all three department sites. Our Corporate Governance team recently chose to prohibit custom columns at the Division level, limiting that customization to the Department level. So I need to move some columns.
Let's say I've got a "NumberOfEmployees" column at the
Division A level. Right now, I'm thinking that I'll need to do the following:
NumberOfEmployees-Tempcolumns; one at each of the Department levels.
Copy & paste the metadata from
NumberOfEmployees-Tempin each Department's data.
NumberOfEmployeesin each of the three Departments.
Is there a less painful way to do this?