Interview Question in Sharepoint Lists


 

Question :: How do you reset the ID column on an ;Issues; list in Microsoft SharePoint

First off, you can't.

Second, here is a way to 'sort of' do it, but you will lose all of your 'created by' and 'created date' and 'modified by' and 'modified dates'.

Export your issues list into Excel. Make SURE you export using a view that shows ALL records (not just where current=yes).

Right-click anywhere in the Excel, and select List -> unsyncronize.

Import the excel file into SharePoint as a brand-new list.

Tweak, repeat until you have something you like.