@zoglow to confirm, you need a unique, consecutive, and static (does not change on deletion/addition) Row ID? The formula
=rowID(thisRow) has been working for me to do this.
On the other hand, if you’re looking for a unique, consecutive, and dynamic (changes with delete/add, so that the series is always constant) ID, I think I have it. It’s a little hacky.
In your table, make a column Static Row ID
=rowID(thisRow) as above. Then, make a column Dynamic Row ID with the formula:
=thisTable.CountIf(RowId(thisRow) > [Static Row ID]).
This counts the number of rows that existed before this row, essentially. I suppose you could also use one of the metadata functions to complete this, which may be faster. The trick, though, is that you need to store the comparison value in a column in order to use it in CountIf()—to my knowledge, at least.
Is that what you’re looking for?