Bug, Missed Release, or Senior Moment (column reference)

J. Craig Williams

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

Mike Wilday

I think we would all prefer option 1 to option 2 and 3. 

Paul Newcome

I've always had this issue (in Smartsheet) when referencing an entire column vs. a specific range of cells. Column:Column doesn't update when moving it, but Column1:Column6 will change to [Column2]1:[Column2]1.

 

But then again... I've only been using Smartsheet for about 3 months now.