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:


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:


one column to the right, I get


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).





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!