Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Drag fill across colomns
I have a sheet with 180 columns, each with a "add sum" *=sum([column name]:[column name]*. I am trying to "drag fill" the add sum across all 180 columns - but the formula does not adjust to the [column name]...any other way of doing this than typing the formula for each column?
TY
Comments
-
Hi Werner,
If you move or copy your formula, the column names and row numbers should update respectively unless maybe you've created an absolute reference with a $?
=SUM([Column1]1 + [Column2]1) is a quick example that should update column names as you drag.
Best,
Kara -
Hi Kara, thanks for you reply - but its not working...please see below:
https://app.smartsheet.com/b/publish?EQBCT=09b543b3e1504c7e82cbc1579602695d
TY
Werner
-
Lets say I have 5 columns named a,b,c,d,e - the formula in column a is: =SUM(a:a) - when I drag fill it to column b,c,d and e - the formula stays =SUM(a:a) - instead of adjusting to =SUM(b:b),=SUM(c:c) etc...?
-
Hey Werner,
Thanks for the example.
If you do a range, the columns will update like: =SUM(a1:a5) will adjust to =SUM(b1:b5).If you are summing an entire column (including the row you are summing) you may see odd behavior as it would be a circular reference at that point.
Hope that helps,
Best,
Kara
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives