Why do my cell formulas not paste when I copy and paste rows?
I have a template, which I have spent a lot of time configuring. I have a set of default rows by product by tier. Once I know which products are launching in a release and what the assigned tier is, I go in and copy that list of deliverables for the given product. When I paste the rows my formulas (which have cell references) are not pasting correctly and I end up with UNPARSEABLE errors. I've tried paste special with "formats" and I get the same result. Given I have about 30 rows per product per tier all with set dates... makes the use of the template less useful given I have to reset all of the dates per product per tier. 😖
This is the formula in the default rows:
This is what gets pasted:
Help Article Resources
Check out the Formula Handbook template!