Bug, Missed Release, or Senior Moment (column reference)
![J. Craig Williams](https://us.v-cdn.net/6031209/uploads/drupal_profile/files/pictures/74/da/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg)
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
Comments
-
I think we would all prefer option 1 to option 2 and 3.
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!