Copying formula across columns

edited 12/09/19 in Formulas and Functions


I'd like to copy a SUMIF formula across columns, where the only change in each would be to have the formula automatically update to match the new column name.

Specifically, it would autmoatically change from the original colum

=SUMIF(Personnel:Personnel, "Alison Michel", [Summer 2018 - Aug]:[Summer 2018 - Aug])


=SUMIF(Personnel:Personnel, "Alison Michel", [Summer 2018 - Sept]:[Summer 2018 - Sept])

to correspond with the new column name.

Copy and past and click and drag aren't working -- is there another solution?



  • Hello,

    There currently isn't a way to automate the changing of column names when you copy a formula over to another column.

    You'll need to manually change the names of the columns that you're referencing as needed after copying your formula to the next column.

    When you have a moment, please submit a Product Enhancement Request (using the form under Quick links on the right of the community site) and let our Product team know that you'd like to see this functionality added to a future version of Smartsheet.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!