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) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.
Help Article Resources
Categories
Check out the Formula Handbook template!