I need a formula that would be based on 2 factors:
1. Sequential - each number would be +1 to the previous number.
2. Date/Year based - the first 2 digits would be the year i.e.
If year is "2008" then:
08000
08001
08002
This will be a column in a list that I am working on for our WSS 3.0
project tracking site. Each Item would have a different sequential
number. Any help?