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

J. Craig Williams
J. Craig Williams ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!