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