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.
I use Rank instead of row id to handle this - take a look at -
Thank you Mallika. That did the trick