#### 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

Options
edited 12/09/19

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

• Employee
Options

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

• Options

Hi Kara, thanks for you reply - but its not working...please see below:

https://app.smartsheet.com/b/publish?EQBCT=09b543b3e1504c7e82cbc1579602695d

TY

Werner

• Options

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

• Employee
Options

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

This discussion has been closed.