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!!