Any way to auto generate a consecutive number when another field filled?

[Geogeo]

Is there any way that an auto consecutive number can be added to first column when a user fills in the title on the next line?

I've attached an example so when the next line filled in sheet would auto fill first column with ABC-004 then next line ABC-005 etc.

[Pete_UK]

You could use this formula in A2:

=IF(B2="","","ABC-"&TEXT(ROW()-1,"000"))

and copy down beyond your data.

Hope this helps.

Pete

[benishiryo]

hi Geogeo, 1 way is to paste this formula on your existing Cell A2:A4 1st:
="ABC-"&TEXT(ROWS($C$2:C2),"000")

then convert this into a Table by pressing CTRL + T. after that, whenever people type on the next cell in column B, the formula in A still exist

[Geogeo]

Thank for the quick replies