SharePoint calculated column formula in List not consistent

%3CLINGO-SUB%20id%3D%22lingo-sub-3238370%22%20slang%3D%22en-US%22%3ESharePoint%20calculated%20column%20formula%20in%20List%20not%20consistent%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3238370%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20custom%20column%20that%20uses%20this%20formula%20to%20create%20a%20unique%20ID%3A%3C%2FP%3E%3CP%3E%3DCONCATENATE(Section%2CREPT(0%2C4-LEN(ID))%2CID)%3C%2FP%3E%3CP%3EIt%20works%20fine%20most%20of%20the%20time%2C%20then%20it%20seemingly%20drops%20the%20ID%20value.%20One%20thing%20to%20mention%20this%20ID%20value%20is%20the%20system%20generated%20value%20found%20in%20the%20ID%20column%20of%20any%20SharePoint%20List%2C%20not%20a%20user%20created%20column.%20So%20for%20example%20the%20first%20item%20has%20a%20unique%20identifier%20of%26nbsp%3B%20ABC0001%2C%20the%20tenth%20has%20ABC0010%20and%20so%20on.%20That%20worked%20fine%20and%20then%20i%20noticed%20that%20the%20unique%20number%20for%20what%20once%20was%20ABC0005%20is%20now%20ABC0000.%20If%20i%20go%20to%20the%20calculated%20column%20and%20update%20the%20parameters%20in%20the%20formula%20it%20will%20update%20and%20resume%20showing%20the%20correct%20value%2C%20ABC0005%20for%20this%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20ID%20is%20a%20system%20generated%20value%20and%20this%20formula%20is%20embedded%20in%20a%20column%20what%20could%20cause%20it%20not%20evaluate%20the%20formula%20to%20true%20and%20thus%20the%20unique%20ID%20randomly%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3238370%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ecalculations%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eformula%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a custom column that uses this formula to create a unique ID:

=CONCATENATE(Section,REPT(0,4-LEN(ID)),ID)

It works fine most of the time, then it seemingly drops the ID value. One thing to mention this ID value is the system generated value found in the ID column of any SharePoint List, not a user created column. So for example the first item has a unique identifier of  ABC0001, the tenth has ABC0010 and so on. That worked fine and then i noticed that the unique number for what once was ABC0005 is now ABC0000. If i go to the calculated column and update the parameters in the formula it will update and resume showing the correct value, ABC0005 for this example.

 

Since ID is a system generated value and this formula is embedded in a column what could cause it not evaluate the formula to true and thus the unique ID randomly? 

0 Replies