Auto populate adjacent cells with data

[IWebb]

I think I am missing something blindingly obvious. I have searched for answers but they all come up with fill answers and that is not what I want.

In the linked sampless.odf I would like learn to auto populate cells in columns ID & Week No without auto filling. If I type a date I would like the values to the left be created automatically.

Currently I am using 60+ sheets and using auto fill / dragging down is causing errors that I have to search for. I have started to look at databases and tables which I hope progress to but that is a few weeks away at present.

Your help is appreciated
SampleSS.ods (8.4 KB)

[karolus]

Hallo
Enter into C3: =IF(D3="";"";WEEKNUM(D3))
Enter into B3 =IF(C3="";"";MAX($B$1:B2)+1)

unfortunately you are forced to filldown both formulas by yourself … NO AUTOFILL for the Formulas provided

[IWebb]

Hi
Thanks for the input, it is appreciated
I was hoping to not have to auto fill as I keep finding errors if I forget to fill down on a sheet
I might have to use excel tables until I can learn base better

[mikekaganski]

@karolus

NO AUTOFILL for the Formulas provided

It seems to me that autofill works also for formulas - both Ctrl+D (selecting B3:D9 first), and double-clicking the mark at the bottom right

@IWebb

until I can learn base better

Base?

[karolus]

@mikekaganski : right, I know about Autofill… but anyway it needs some action by $User

[mikekaganski]

Ah - OK, I see it’s just a wording issue; the OP user “auto populate”, “without auto filling”; and you replied to that; I only looked at your answer, without the context, sorry. (Nitpicking: still, it’s not “autofill” that you were talking about )