I am at loss here, please help.

I have a list and for every item in the list, I need its ID to look like this:






Number at the end is the order of item submitted in that month.

What I managed so far is to get the right format of the date by using this: =TEXT(Created,"yyyy")&TEXT(Created,"mm")&"-"

How do I calculcate the order of new items to start from 1 for each month?

Thanks a lot!!

  • If Amal answered your question, then please mark it as answered Feb 6, 2016 at 21:39

1 Answer 1


Calculated column can look values from only the current item. It doesn't have the capability to look across the list items and take a decision.

Your best option is to create an item event receiver or use a SharePoint Designer workflow that get fired on new item add.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.