### Automatic numbers lost in sort Table

Posted:

**2019-07-08 10:55:35**Hi,

I'm attempting to put a column of automatic numbers in a Table, each representing a 'Scene #' in a long book, which I was hoping to use to re-sort the table into that order again later. They add nicely and quickly in the column.

However, if I then sort the table by another column (say, 'number of words in scene') then the automatic 'Scene #' column loses its numbers; instead they get re-formulated into the new order after the 'number of words' sort, starting from the top.

My hunch is this problem is unsolvable, but perhaps there's a workaround.

To clarify, restated:

I want to use automatic numbers because I have a table that's 130 rows long whose number of rows will be changed during my editing process, as I define new scenes; I want to add a row here or there, or take one out, and I'd like the automatic numbers column to self-adjust, so the numbering is always accurate.

But as I said, if I sort the Table by any other column, then I can't use the Scene # column to sort it back (which is what it's there for, hopefully), because the numbers all update themselves to the new sort and the original sequence is lost.

I know I can do this by adding all the Scene # numbers by hand, but that is painful because then if I add or delete one, all the others need to be updated by hand. So I'd like auto-numbers if possible.

?

wF

I'm attempting to put a column of automatic numbers in a Table, each representing a 'Scene #' in a long book, which I was hoping to use to re-sort the table into that order again later. They add nicely and quickly in the column.

However, if I then sort the table by another column (say, 'number of words in scene') then the automatic 'Scene #' column loses its numbers; instead they get re-formulated into the new order after the 'number of words' sort, starting from the top.

My hunch is this problem is unsolvable, but perhaps there's a workaround.

To clarify, restated:

I want to use automatic numbers because I have a table that's 130 rows long whose number of rows will be changed during my editing process, as I define new scenes; I want to add a row here or there, or take one out, and I'd like the automatic numbers column to self-adjust, so the numbering is always accurate.

But as I said, if I sort the Table by any other column, then I can't use the Scene # column to sort it back (which is what it's there for, hopefully), because the numbers all update themselves to the new sort and the original sequence is lost.

I know I can do this by adding all the Scene # numbers by hand, but that is painful because then if I add or delete one, all the others need to be updated by hand. So I'd like auto-numbers if possible.

?

wF