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

Amit Wadhwani

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?

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.