Copying formula across columns
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?
Comments
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!