Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Google Sheets auto increment column A if column B is not empty

I want to auto increment column A if column B is not empty. For example if I type anything to B14, I want A14 to auto increment.

How can I do this?

enter image description here

like image 200
Volkan Elçi Avatar asked Sep 20 '25 16:09

Volkan Elçi


1 Answers

if B column is not interrupted by an empty cell you are good with just:

=SEQUENCE(COUNTA(B2:B))
like image 123
player0 Avatar answered Sep 22 '25 08:09

player0