I wanted to share this, as I Have not found a solution searching the Forums. It may already be known, but you can create a dynamic sequential numbering system of the rows order from top to bottom of a table, even if you move up or down, delete or add rows to the table.
It took three formula columns.
Formula Column 1 = Create a unique Id from a data columns name + rowID()
concatenate(thisrow.[Name],LeftPad(RowId(thisrow),6,“00000”))
Using LeftPad() with enough zeroes insures you get a Unique ID for the next step.
Replace Name with your main column id.
Formula Column 2 = Create a list of the Column 1
concatenate(“,”,list(thistable.[Column 1]),“,”)
Adding the commas at the end and front of the list will help in the final step.
Do not sort the list, leave as default table order.
Formula Column 3 = Create the sequential numbering from 1 to last number.
split(left(totext(trim(thisRow.[Column 2])),Find(totext(trim(thisRow.[Column 1])),totext(trim(thisRow.[Column 2])))+Length(totext(trim(thisRow.[Column 1)))-1),“,”).Count()
What you are now doing is Counting the number of commas from the left trim Column 2.
You left trim it using the Column 1 find() formula. Which means every time you move data up or down the table, it dynamically renumbers correctly. I use this in a template process table that can have multiple processes moved around based on our mfg builds and assembly instructions to represent the order of those processes.
Again, if there is an easier way, please link me to it, but this is working great so far, and I wanted to share for anyone who needs it.