Hi everyone, I am looking to have a auto sequential number column that keeps sequential numbers even after moving the rows.
For example before moving the rows:
After moving the first row to the bottom, I would like to have the numbers to still be sequentially ordered in the Auto Number column:
I have looked at solutions posted in the past but they all rely on you not moving the first row. In my case, I will need to shift the first row around. Was wondering if anyone has any idea how I can approach this? Thanks!