If you ever use the Miracle method, you need sequential numbers all the time. Not to mention a myriad of other use cases. There are a few solutions floating around, but I’m not sure I’ve seen this one cited. At the same time, it is so stupidly simple, I can’t believe it took me so long to think of it. So it’s entirely possible it’s been posted somewhere and just reemerged for me while I was thinking of something else. If that’s the case and you’re the original author, please let me know. Don’t mean to steal anyone’s thunder
Using the “Find element index” column, we search for “Row ID” values in the “lookup_row_id” array.
And THAT’S IT
Every new row will automatically have an index number associated with it. One caveat that can be both pro and con of this method: if you delete a row, no matter in which part of the table, it gets recalculated automatically.
Amazing, I couldn’t believe it wasn’t mentioned before, but searching through this forum did not yield the expected results Well, unless admins think this is a waste of space, let it sit here for linking purposes