Ok, I need to be able to create a column in a document list that automatically provides a tracking number. I used the ID column but the client don't like its format (sigh). So, what I need is something like:
2012FSP-0001, 2012FSP-0002, etc.
I have this partly working by using a calculated field with =YEAR(Created)&"FSP-" but how could I get the appended numbers to auto increment?
Also, this needs to be reset-able (is that word) so that in 2013 it would start at 1 again. 2013FSP-0001, 2013FSP-0002, etc.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.