0

I'm working on SharePoint Online (new excperiance) and I've created a document library at the Site Content Types. For that type I'll have a column with auto increments and starting with TN. For this I create a column type of Calculated (calculation based on other columns).

At the Additional Column Settings, I'm using this formula

= "TN" & [ID]

and The data type returned from this formula is: Single line of text.

But when I save, I've got next error:

Sorry, something went wrong: The formula refers to a column that does not exist. Check the formula for spelling mistakes or change the non-existing column to an existing column.

I've added a hidden column ID to the list.

Did I something wrong? I've seen on this Stack Overflow question that my formula is correct.

  • What is the internal name of ID column? – Ganesh Sanap Dec 14 '18 at 9:09
  • @GaneshSanap: I've found that ID was a part of a custom group I created. I think this is wrong and deleted that. I don't use that. But now I don't have any identifier anymore... – H. Pauwelyn Dec 14 '18 at 9:17
  • 1
    it is not best practice to use sharepoint default ID column in calculated column formula. To Auto increment field. you can use workflow and set the fields. – Ganesh Sanap Dec 14 '18 at 9:22
1

Using SharePoint default ID column in the calculated columns is not good option because ID will created after item added successfully in the list.

Even thought ID column is not in the list of "Insert Column" fields while creating formula, IDs can work in calculated columns just by writing [ID] in formula. But, they are unreliable as the calculated column will get updated only if the item is edited/changed.

Solution:

Use Workflow : If you need to use the ID column in a calculation, the best approach is to do the calculation in a workflow and set a column to the value returned by the calculation.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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