Need a way to fix row id, so they do not move

Hi,

Little background, I am using below formula to get the row id in RowID column

=COUNTIFS($Name$1:Name@row, OR(@cell = "", @cell <> ""))

Now whenever I sort my sheet on the basis of date, the row ids also changes because the absolute reference changes. I am fine with sorting but I want the Row ID to always start with 1 and so on.. (i.e. it should remain same), anyway to achieve this?

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

If you insert an extra row at the top and indent everything below it, the sort will only sort the child rows.

Or instead of indenting you could insert a checkbox column and check the box then the first tier of your sort would be the checkbox column being in descending order.

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.