Is there a way to create a column that re-numbers automatically when rows are moved around?

I feel silly that I cannot seem to figure this out. Is there a way that a column can contain a number that updates automatically when rows are moved around? For example, if the rows are numbered 1, 2, and 3 - in order, and then I move row 3 in between rows 1 and 2, I want that cell to automatically update to become 2 and the one that used to be 2 now becomes 3. Thanks!

Find more posts tagged with

Formulas

functionality

Project Management

Accepted answers

jjg279

Hey Amanda! There is; I have used it, and love it:

You do need two columns - one to fill with "1"s as a column formula and they other as the actual index. The formula for the index columns is =COUNT([1-Column-Name]1:[1-Column-Name]@row

All comments

jjg279

Hey Amanda! There is; I have used it, and love it:

You do need two columns - one to fill with "1"s as a column formula and they other as the actual index. The formula for the index columns is =COUNT([1-Column-Name]1:[1-Column-Name]@row

Amanda Bean

Thank you!!!!! Much appreciated.

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.