I have created a 'List' called 'Issues Tracker' that we are using to open/update/close issues. Right now the 'Issue Number' field is entered manually when creating or updating an issue. How can I make this field automatically populate the next number (based on the number of the last issue created) when a user creates a new issue? Thanks!

My suggestion is that you just ust the ID column that exists with every list. Just make that column visible

Thanks for the suggestion, but I originally avoided using the IssueID as the issue number because I had an existing issues log prior to creating this list in SharePoint and needed to keep my original issues numbers intact. The IssueID would have started at 1. I am thinking I could make my Issue Number field a calculated value (instead of manually entered as it is currently) using Issue ID + 1000. Do you know how to write this? I did some quick google-ing and came up with a lame effort that did not work ( ="IssueID"+1000 ). Let me know if you know how to write something simple like this or point me in the direction of a tutorial/user guide to review. Thanks again!

I dont think that will work. You are going to need to embed some code on the new screen to be able to calculate the column and add the the value to the column befor e the page is posted

> ( ="IssueID"+1000 ). This works (almost) if you use [ID]+1000 which then converts to =ID+1000 (call the calculated column IssueID but use the correct field/column name of ID in your calculated field) Almost because in the View the column is shown as 1,001 , 1,002 etc. i.e. with a comma for the thousands. That might however be OK for you. P.S. David Lewis was right. The above works fine for items which already existed at the time the Calculated Column was created. But for any new item added after the calculated column has been created, it (always) give 1,000 (Leaving this in so no-one else comes up with the same - wrong - suggestion.) 2010 Books: SPF 2010; SPS 2010; SPD 2010; InfoPath 2010; Workflow etc. 2007 Books: WSS 3.0; MOSS 2007; SPD 2007; InfoPath 2007; PerformancePoint; SSRS; Workflow Both lists also include books in French; German; Spanish with even more languages in the 2007 list.

Hi You can achieve this with Event handler list item adding Event. Steps to Write custom event handler: open the site collection.open the web .get your list and check weather there is a record or not using spquery if not generate a number in the format like 001 if you already have a record in the list with the list id and increment by 1 and add it to list number filed in the list. hope this help you. tell me if you want programing i will do for you Thanks, Nivas