Auto increasing reference number

Hi sp16879,

you can use a combination of calculated columns and workflows. Here's a step-by-step approach to setting it up:

1. Create two columns in your SharePoint list:
- "Year": Set the data type as "Number" and set a default value to the formula `=YEAR([Created])`.
- "Sequence": Set the data type as "Number" and set the default value to 1.

2. Create a calculated column named "Reference Number" with the following formula:

="MI-TEC-" & RIGHT(TEXT([Year],"00"),2) & "-" & TEXT([Sequence],"0000")

This formula combines the static text "MI-TEC-", the last two digits of the "Year" column, and the "Sequence" column value formatted with leading zeros.

3. Save the list settings to apply the calculated column.

4. Create a SharePoint Designer workflow to increment the "Sequence" column every time a new item is added to the list. Here's an example:

- Set the workflow to trigger on item creation.
- Add an "Update List Item" action to the workflow.
- Set the "Field" to "Sequence" and the "Value" to "Current Item:Sequence" plus 1.
- Save and publish the workflow.

Now, when you add a new item to the list, the "Sequence" column will automatically increment, and the "Reference Number" column will be updated accordingly with the format "MI-TEC-YY-XXXX", where YY represents the last two digits of the current year, and XXXX is the unique number.