Auto sequential numbering even after moving rows

Hi everyone, I am looking to have a auto sequential number column that keeps sequential numbers even after moving the rows.

For example before moving the rows:

After moving the first row to the bottom, I would like to have the numbers to still be sequentially ordered in the Auto Number column:

I have looked at solutions posted in the past but they all rely on you not moving the first row. In my case, I will need to shift the first row around. Was wondering if anyone has any idea how I can approach this? Thanks!

Find more posts tagged with

Formulas

Accepted answers

Michelle Choate 2

Well you are not going to be able to do it in your auto number column. You will need to add one additional column. The formula is:

=MATCH([Row ID]@row, [Row ID]:[Row ID], 0)

Now you can move around your rows as much as you want.

All comments

Michelle Choate 2

Well you are not going to be able to do it in your auto number column. You will need to add one additional column. The formula is:

=MATCH([Row ID]@row, [Row ID]:[Row ID], 0)

Now you can move around your rows as much as you want.

Happykamper56

Wow @Michelle Choate 2 This worked perfectly! Thank you for the quick response!

Michelle Choate 2

My pleasure! Make sure to accept my response as the best answer to your question.

RSC

Hi Michelle, thank you so much for this formula, I have used it to sync information using datamesh. However I found that the formula stopped working on my source sheet - there are duplications of row numbers and the row numbers are not sequential…. do you have any idea what could be happening? It has been working for months, until now…

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.