I have a Google sheet that has a sequence of numbers in the left column:

I'd like to write an array formula in A1 that automatically adds the next number in the sequence when a new row is added to the sheet.

For example, if I add a row 8, an 7 (the next number in the sequence) automatically fills in cell A8. I've tried this with the Sequence function, but that requires a pre-defined number of rows. I've also tried to do an array formula that uses something like "A3=A2 1", but I can't get the syntax to work in an array.

CodePudding user response：

Try the following in cell A1:

={"Sequence";sequence(rows(A2:A))}