This is a simple bit of Google Sheets formula used to add a row of incremental number is row A where row B is not blank.
Handy for when you get sick of copying and pasting the same formula down any new rows you add to a sheet.
=ARRAYFORMULA(IF(B2:B<>"", ROW(B2:B) - ROW(B2) + 1, ))Hopefully this will make someone’s google search a bit quicker.
Leave a like or a comment if it helped!
