Hi

Hope I can get some help here.

We have a sharepoint list, where we have a column "Issue Id"

Each time we create new entry, the ID increments itself by 1.

It was all working fine until last week, when our office migrated Sharepoint to Office 365. Since then the list ID numbers are out of whack.

All the existing Issue Id's have been auto Incremented by around 140 ..so rather than the first issue in the list that started at 1, it starts at 143 now. Before the migration thew total Issue Id's we had were from 1 - 146. and now we have 143 - 286.

This causes several issues for us as we generate our Quote numbers through this. For Example, the last quote we generated through this list wa number 146, but now because the list has been incremented by around 140, it says the quote is 286.

Will Appreciate if I can get some help on this

Not sure about this behavior, but a following workaround you can use.

You can create a new Calculated column which would be calculated as ([ID] - 143)

And you can use new column for your reference.