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 ?

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

4 Answers 4

Reset to default
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.

Improve this answer
2
  • This is not for me, without WorkFlows :D
    – Goshky
    Apr 1, 2016 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, 2016 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!

Improve this answer
0

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

[ID]

Place the id here

Improve this answer
9
  • How to do it ? I'm a beginner with SP..
    – Goshky
    Apr 1, 2016 at 9:51
  • added an Image thats Shows where to place it.
    – Raoul Mensink
    Apr 1, 2016 at 10:41
  • This is valid for SharePoint 2007 ?
    – Goshky
    Apr 1, 2016 at 10:44
  • and column type must be a ?
    – Goshky
    Apr 1, 2016 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, 2016 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!

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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