Creating a Calculated Column using Existing Document Properties

%3CLINGO-SUB%20id%3D%22lingo-sub-1072491%22%20slang%3D%22en-US%22%3ECreating%20a%20Calculated%20Column%20using%20Existing%20Document%20Properties%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072491%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Folks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20implement%20a%20standard%20naming%20convention%20for%20our%20documents%20by%20using%20existing%20document%20properties.%3C%2FP%3E%3CP%3EBasically%2C%20I%20would%20like%20to%20create%20a%20new%20(Calculated)%20Column%20called%20DNS%20using%20the%20following%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%5BField1%5D%20%26amp%3B%20%22%20-%20%22%20%26amp%3B%20%5BField2%5D%20%26amp%3B%20%22%20-%20%22%20%26amp%3B%20%5BField%203%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EField1%20is%20the%20Project_ID%20(Managed%20Metadata%5D%20inherited%20from%20the%20folder%3CBR%20%2F%3EField2%20is%20the%20File_Number%20column%20(Managed%20Metadata%5D%20inherited%20from%20the%20folder%3CBR%20%2F%3EField3%20is%20the%20Name%20column%20(document%20name)%20entered%20by%20the%20user%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EHere%20are%20my%20issues%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B1.%20None%20of%20the%20Managed%20Metadata%20fields%2Fcolumns%20are%20available%20in%20the%20column%20list%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B2.%20The%20Name%20column%20which%20I%20assume%20is%20the%20standard%20column%20for%20all%20content%20type%20is%20not%20displayed%20as%20well....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20around%20these%20problems%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%2Ffeedback%20would%20be%20greatly%20appreciated%20and%20would%20make%20its%20way%20to%20Santa's%20favorite%20list....%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20and%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGilles%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1072491%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi Folks!

 

I am trying to implement a standard naming convention for our documents by using existing document properties.

Basically, I would like to create a new (Calculated) Column called DNS using the following formula:

 

=[Field1] & " - " & [Field2] & " - " & [Field 3]

 

Field1 is the Project_ID (Managed Metadata] inherited from the folder
Field2 is the File_Number column (Managed Metadata] inherited from the folder
Field3 is the Name column (document name) entered by the user

Here are my issues:

   1. None of the Managed Metadata fields/columns are available in the column list

   2. The Name column which I assume is the standard column for all content type is not displayed as well....

 

Is there a way around these problems?

 

Any help/feedback would be greatly appreciated and would make its way to Santa's favorite list.... :)

 

Thank you in advance and regards,

 

Gilles

0 Replies