I am pretty sure that if I had a formula like this:
=SUM(A:A)
where A is a column, if I copied that to another column, it would update (ie, was a relative reference)
It doesn't.
If I copy this formula:
=SUM(A1:A6)
one column to the right, I get
=SUM(B1:B6)
as expected.
There are three options:
1. This is a (newish) bug
2. I missed a Release (checked back to 2017 and did not see any reference to this)
3. I'm having a brain fart / senior moment
My preferred option is (#1).
Craig
