Copy or Move rows to another sheet do not copy formulas

At the end of every sprint, I want to move data for this sprint to an archive sheet. When I move or copy rows to another sheet, the cell formulas are not getting copied. Only the values (without formulas and cross-sheet references) are getting copied. I tried the automation option and manual copy/move. But none of these processes copy formulas and cross-sheet references. Is this behavior intentional? Is there a way to copy over the formulas and cross-sheet references?
Answers
-
Hi,
Check out this thread which has a nice trick for making it easier to copy and paste formulas between sheets:
If you type a ' before your formula, you can copy the row, paste it into your new sheet, and the formula will apply correctly. I believe that this is the best way to do it at the moment.
Hope this helps!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)
SSFeatures - The browser extension that adds essential features into Smartsheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!