This monday.com app provides a recipe called AutoID Column. When added to the board the recipe can be configured with the sentence:
When a new item is created, generate an auto-increment ID – preceded by this text and starting with this number (with the minimum number of digits) – in this column.
The text column specified in this column will be automatically populated with an ID which is preceded by the specified (this text) and starts with this number. The number of digits variable specifies the minimum number of digits. An ID can look like this INV-0100.
It is highly recommended to lock the ID column by clicking the down arrow and choose Column Permissions > Restrict column edit.
When you change the recipe configuration (e.g. when you configured the year as part of the preceding text) you can simply create a new item with the name “RESET AUTOID”. This will reset the increment counter after which you can safely delete this temporary item.