I am trying to create a formula to have the cells in column A auto populate with 2020-XXX, with the XXX being the end number in the cell directly above it. Column A row 1 is 2020-001, Column A row 2 would then be 2020-002 etc..
I have tried a number of different formulas but none work. Has anyone accomplished this before and if so would you be willing to share the formula?
Thanks
AJ
One way would be to do something like this:
In A1, filled down:
="2020−"&RIGHT("00"&ROW(),3)
Substitute ; for , if your region uses , as a decimal separator.
SG
Again, you do not need a formula.
Just enter "2020—001" (em dash, no hyphen!) in cell A2 and then fill down from the cell A2.
Paul.
Judging from your screenshot the formula seems to be working in rows 2 and below.
In row 1 try selecting the cell, hitting <delete>, then go to the panel at the right and format as Automatic. Then reenter the formula in that cell.
For basic operations in Numbers such as fill I highly recommend spending a little time at Help > Numbers Help in your menu. There are a lot of useful explanations there.
SG
No, without a formula you need to fill down after adding a row.
Or, with the SG formula, you need to hit the "ENTER" key for adding a row "automatically" and at the same time having the formula filled in "automatically" in the added row.
Paul.
Paul.
Thank you for the input.
Unfortunately I am doing something wrong as I am not sure why I am getting this.
Perhaps I am putting the formula in the wrong place?
Paul,
Thank you. I tried that but when I add a row below, it does not fill in automatically.
Ok. Thank you. I guess I don't know what "fill down" means.
Format Numbers cell to auto enter the number in the cell above +1 in each new row
