Why do formulas only work in half my cells?

[Malthus101]

Hey

So I have a simple sheet I use every week to keep track of trading records.

I have a template which I copy and then populate each week.

When I fill in the details from the top down as the week progresses, the cells with formulas in them are not auto-populating the calculation results. I have to drag down from the top cell to fill the cell with the answer below. Yet later on down the sheet, the cells start populating with the forumula answers by themselves.

I'd like them all to do it.

Why's this happening and how can I fix it in the template sheet?

Thanks!

 

[Malthus101]

No. But you could set that up in your template.

What I'm asking is, why did some of the cells used to populate themselves with the formula answers if I hadn't put them in there?

 

[Peter_SSs]

What I'm asking is, why did some of the cells used to populate themselves with the formula answers if I hadn't put them in there?

If the formulas were not there and hidden by CF then that leaves the first 3 options I mentioned previously as the only ways I can think of it happening.
I have no way of knowing which of those options it was, or perhaps if there might be some other way.