Keep RowID formula from counting deleted rows

[Brandon_Cole]

Right now I have RowID(thisrow) as a formula for one of my columns. I would like it to only count rows that haven’t been deleted. Is this possible? For example I deleted the row that had row id 1 now my column just shows 2, 3, 4.

[mallika]

Hi Brandon,
I use Rank instead of row id to handle this - take a look at -

Consecutive Row Numbers?

I know there must be a simple solution to this, but I cannot find it for the life of me. So, I need to have a column where each row has a unique consecutive number ranging from 1 to however many rows I have. I cant use rowId because if I delete any rows and then add new ones, the number will be wrong. Such a simple problem, but it is holding nearly all of my docs back from being made correctly

[Brandon_Cole]

Thank you Mallika. That did the trick