@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?