Incrementing last number without AutoNumber?

Hello @JPJPJP,

On of the reasons for using AutoNumber (Column Type: Auto-Number/System ) is actually to prevent the number is reused if someone accidently or on purpose deletes a row. So Autonumbers do not shift, but retain the same ID as originally was given to.

So your question about not using AutoNumber because the autonumbers will shift, does not make sense to me. Perhaps you mean something else, rownumber maybe which indeed will shift when deleting rows?

Regarding your second question: of course you can use a seperate sheet metadata which will keep track of the latest number (of both sheets: original and Archived). using the MAX in combination with Reference to the original and Archive sheet.

However any new rows added to the original sheet however do not need to 'look' at this Metadata sheet as all ID's are originated from the original sheet and therefor already unique. Perhaps you can look at my answer for your first question again to see if this metadata sheet is still needed ?

@JPJPJP

You're more than welcome!

No worries!

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!