I am creating a column in SharePoint list. This column is calculated.
I am using below formula as of now: =""&"INC0000"AutoID
This shows results like: INC00001
, INC00002
, etc.
I want to change and show results like: 20151
, 20152
, etc.
Where 2015
is current year and 1
,2
is ID.
If user enter data next year then output should be like 20161
, 20162
, and so on. Year should be current.
Please anyone can share formula for this. Thanks