2

I have a column with name "Title " and want to make my column be a auto increment (1, 1) with Calculated column option. How to do it ?

  • There is a ID column which get auto incremented by 1. Why don't you use that? – P S Apr 1 '16 at 9:41
  • Because, I do not know how to use it. – Goshky Apr 1 '16 at 9:52
3

Best is that use ID column. It is not possible with only calculated column option. You have to set workflow for auto increment value.

  • This is not for me, without WorkFlows :D – Goshky Apr 1 '16 at 9:53
  • Just add ID column in list view. Go to Modify view >> Checked ID column from columns section and save it. You can visible ID column in list. – Viraj Gorajia Apr 1 '16 at 10:00
1

It is possible with a Calculated Column,
but the Workflow method of incrementing is the best way to go.

If you can not do Workflows and are stuck to Calculated Columns then the full details are at:

Why you can not use [ID] : Calculated column with ID removes ID number on update

How to workaround it: Create unique number with ListItem [ID] and [Today] age in Calculated Column Formula

DISCLAIMER This is not for the faint of heart!

0

You can use the auto increment value from the id field and put it in the formula field:

[ID]

Place the id here

  • How to do it ? I'm a beginner with SP.. – Goshky Apr 1 '16 at 9:51
  • added an Image thats Shows where to place it. – Raoul Mensink Apr 1 '16 at 10:41
  • This is valid for SharePoint 2007 ? – Goshky Apr 1 '16 at 10:44
  • and column type must be a ? – Goshky Apr 1 '16 at 10:45
  • 1
    Do not use the ID field within a calculated field: - You will have trouble inserting a record. It will work well in the modification. - It is not officially supported by Microsoft – Juan Pablo Pussacq Laborde Apr 1 '16 at 12:23
0

Alternatives

1) Use ID

It is the best option because SharePoint ensures its uniqueness. But you can not apply business logic. It starts at 1 and increases by 1. You will have gaps when records are deleted.

2) Event handler

Create an event receiver to generate increased values according to the logic that you need. You need Visual Studio and C#.

3) Workflow

It can be an alternative. But workflows are not planning for it. The advantage is that you do not need to develop in C# as in option 2.

Important

Do not use the ID field within a calculated field: - You will have trouble inserting a record. It will work well in the modification. - It is not officially supported by Microsoft

If you need further assistance, please consult me. Greetings!

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.