Copy document library columns across multiple libraries

%3CLINGO-SUB%20id%3D%22lingo-sub-1954880%22%20slang%3D%22en-US%22%3ECopy%20document%20library%20columns%20across%20multiple%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1954880%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20creating%20a%20contract%20manager%20within%20Sharepoint.%3C%2FP%3E%3CP%3EI%20have%20different%20groups%20of%20contracts%20and%20a%20lot%20of%20them%20have%20the%20same%20basic%20metadata%20and%20then%20a%20good%20amount%20of%20columns%20will%20be%20different%20between%20them.%3C%2FP%3E%3CP%3ESo%20I'm%20putting%20them%20into%20different%20document%20libraries%20within%20the%20same%20site.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20quickly%20create%20or%20copy%20the%20columns%20that%20all%20of%20the%20document%20libraries%20should%20have%20in%20common%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%20%3CSTRONG%3EExpiration%20Date%3C%2FSTRONG%3E%20should%20be%20a%20column%20that%20is%20in%20each%20of%20the%20document%20libraries%2C%20but%20something%20like%20%3CSTRONG%3EType%20of%20Airfare%3C%2FSTRONG%3E%20shouldn't%20be.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22columns.PNG%22%20style%3D%22width%3A%20738px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F237638i7D33F43C92680976%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22columns.PNG%22%20alt%3D%22columns.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20tried%20following%20instructions%20from%20here%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-column-in-a-list-or-library-2b0361ae-1bd3-41a3-8329-269e5f81cfa2%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-column-in-a-list-or-library-2b0361ae-1bd3-41a3-8329-269e5f81cfa2%3C%2FA%3E%3C%2FP%3E%3CP%3Eunder%20%3CSTRONG%3EAdd%20an%20existing%20site%20column%20to%20a%20list%20or%20library%20%3C%2FSTRONG%3Ebut%20it%20didn't%20show%20any%20of%20the%20columns%20I%20had%20created%2C%20just%20prebuilt%20ones.%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20other%20ideas%20that%20I%20can%20try%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1954880%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1955234%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20document%20library%20columns%20across%20multiple%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1955234%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F890562%22%20target%3D%22_blank%22%3E%40bingr001%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20use%20same%20column%20across%20multiple%20lists%2Flibraries%20then%20it%20is%20recommended%20to%20create%26nbsp%3B%3CSTRONG%3ESite%20columns.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3ETo%20create%20site%20columns%20you%20can%20follow%20the%20steps%20given%20in%20%3CSTRONG%3E%3CSPAN%3ECreate%20a%20site%20column%20in%20a%20list%20or%20library%3C%2FSPAN%3E%3C%2FSTRONG%3E%20section%20in%20the%20same%20link%20you%20provided.%3C%2FP%3E%3CP%3EMake%20sure%20you%20remember%20the%20the%20Group%20where%20you%20are%20creating%20site%20columns.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20you%20can%20add%20site%20columns%20to%20your%20lists%2Flibraries%20using%20the%20steps%20given%20in%26nbsp%3B%3CSTRONG%3E%3CSPAN%3EAdd%20an%20existing%20site%20column%20to%20a%26nbsp%3Blist%20or%20library%3C%2FSPAN%3E%3C%2FSTRONG%3E%20section.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20you%20can%20select%20the%20site%20columns%20group%20where%20you%20created%20columns%20earlier%20in%26nbsp%3B%3CSTRONG%3ESelect%20site%20columns%20from%3A%3C%2FSTRONG%3E%20drop-down.%20It%20will%20be%20easier%20to%20filter%20and%20select%20the%20columns%20you%20created.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20following%20this%2C%20let%20me%20know%20if%20you%20are%20still%20not%20able%20to%20see%20the%20site%20columns%20you%20created.%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%20%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm creating a contract manager within Sharepoint.

I have different groups of contracts and a lot of them have the same basic metadata and then a good amount of columns will be different between them.

So I'm putting them into different document libraries within the same site.

Is there a way to quickly create or copy the columns that all of the document libraries should have in common?

 

For example Expiration Date should be a column that is in each of the document libraries, but something like Type of Airfare shouldn't be.

columns.PNG

I tried following instructions from here: https://support.microsoft.com/en-us/office/create-a-column-in-a-list-or-library-2b0361ae-1bd3-41a3-8...

under Add an existing site column to a list or library but it didn't show any of the columns I had created, just prebuilt ones.

Does anyone have any other ideas that I can try?

1 Reply

@bingr001 

If you want to use same column across multiple lists/libraries then it is recommended to create Site columns.

To create site columns you can follow the steps given in Create a site column in a list or library section in the same link you provided.

Make sure you remember the the Group where you are creating site columns. 

 

Then you can add site columns to your lists/libraries using the steps given in Add an existing site column to a list or library section.

 

Here you can select the site columns group where you created columns earlier in Select site columns from: drop-down. It will be easier to filter and select the columns you created.

 

After following this, let me know if you are still not able to see the site columns you created.


Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.