Incrementing last number without AutoNumber?

Hi there,

Is there a way when a new row is added, to increment the ID number from the previous row without using AutoNumber?

We have Project ID's that can't risk being changed (i.e. if someone accidently deletes a row and all the autonumbers shift), and sometimes certain rows might be moved to an 'Archive' sheet where it needs to retain the ID number.

2nd question - Is there a way to have a separate 'metadata' helper sheet, that keeps track of the latest number, since the row can move between sheets? That way any new rows use that latest number and then updates the metadata sheet every time?

Best Answer