Keep RowID formula from counting deleted rows

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.

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

Thank you Mallika. That did the trick

1 Like