Autonumber ID to reset itself on month change

[codecomm]

We have a "To do" list that also has a "month" column.

We'd like to have the todos in March to start with 1, and once we started entering in items for April, the first todo entered would start @ 1, then second todo would be 2, etc.

Calculated field maybe??????

Any suggestions are welcome!

Thanks!

 

[ehaze]

Have you looked into event handlers?
you can code all the logic and "what if's".

possible way to get it done using workflow(s):

http://social.msdn.microsoft.com/fo.../thread/867bcacd-d378-411a-849a-fc040de9e5da/

http://www.sharepointed.com/