I am new to the formula side of Google Sheets and am trying to get each row to add 1 to the previous row ex. A2=A1+1, A3=A2+1. I know I can use =A1+1 and drag it down, but I want it to continue if a row is added in between. Can an array formula work?

I am new to the formula side of Google Sheets and am trying to get each row to add 1 to the previous row ex. A2=A1+1, A3=A2+1. I know I can use =A1+1 and drag it down, but I want it to continue if a row is added in between. Can an array formula work?

I am new to the formula side of Google Sheets and am trying to get each row to add 1 to the previous row ex. A2=A1+1, A3=A2+1. I know I can use =A1+1 and drag it down, but I want it to continue if a row is added in between. Can an array formula work?

I am new to the formula side of Google Sheets and am trying to get each row to add 1 to the previous row ex. A2=A1+1, A3=A2+1. I know I can use =A1+1 and drag it down, but I want it to continue if a row is added in between. Can an array formula work?

I am new to the formula side of Google Sheets and am trying to get each row to add 1 to the previous row ex. A2=A1+1, A3=A2+1. I know I can use =A1+1 and drag it down, but I want it to continue if a row is added in between. Can an array formula work?

I am new to the formula side of Google Sheets and am trying to get each row to add 1 to the previous row ex. A2=A1+1, A3=A2+1. I know I can use =A1+1 and drag it down, but I want it to continue if a row is added in between. Can an array formula work?

I am new to the formula side of Google Sheets and am trying to get each row to add 1 to the previous row ex. A2=A1+1, A3=A2+1. I know I can use =A1+1 and drag it down, but I want it to continue if a row is added in between. Can an array formula work?