My team is trying to create a custom ID column for our SharePoint 2010 list. The column should show YYMMDD-ID, with YYMMDD the date the item was created and ID the ID of the item. I tried using =[DateCreated]&"-"&[ID] in a custom column which worked until you update the item and then the ID number disappeared. I researched that since ID is not a string this happens and the workaround is to create a workflow.
I'm unsure on how to do this, has anyone ever created something like this before? Is there a way of just using a custom column?
My team appeciates any help!