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 ?
Best is that use ID column. It is not possible with only calculated column option. You have to set workflow for auto increment value.
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!
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#.
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.
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!