Copying formula across columns

AMichel
AMichel ✭
edited 12/09/19 in Formulas and Functions

Hi,

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])

to

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

Tags:
· Share on FacebookShare on Twitter

Comments

  • Shaine Greenwood
    Shaine Greenwood Employee

    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.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!