Adjust the order of the rows when a new row is inserted
I have a sheet which contains a list of flow steps. I have numbered them in a particular manner (1,2,3,4,5,6....). If I want to add a step somewhere in between I want the number of all subsequent steps to adjust to the next number.
This order is important and needs to be retained.
I do not want to use Auto numbering, rather I want to dictate the sequence myself.
I would do such a thing in excel by using the Row() function. Is there anything similar I can do here. I would prefer to use formulae so that I can convert it to a column formula.
I can use this column for sorting in reports to retain the order of steps