Copy or Move rows to another sheet do not copy formulas

pd_njit

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?

SSFeatures

Hi,

Check out this thread which has a nice trick for making it easier to copy and paste formulas between sheets:

https://community.smartsheet.com/discussion/65209/quick-way-to-copy-formulas-across-sheets-i-found

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!