copy rows with formula's

When I copy a row from one sheet to another sheet; all the formula's in the cells are replaced with values in the target sheet. So my formulas are gone in the new row that appears to the target sheet. Is there a way to have the formulas copy over in the row so they are intact in the target sheet?

Find more posts tagged with

Education

Formulas

IT & Operations

Comments

SashaR

formulas are specific to each sheet (row/column references are different across sheets) which is why they are not copied over. If you want to copy the exact formula, you could double click in the cell containing the formula, copy the formula, then paste it in the new cell.

John Bandy

Ok, maybe there are other ways to accomplish my goals. So, I have a sheet that has a whole lot of formulas; I would like to save that as a template for people to use and have people create sheets based on the template. The team needs to be able to move a copy rows between other team members sheets, but the formulas are stripped everytime, even though the columns are identical. It doesn't work well for them to share the same sheet, because they are always being updated and you get refresh and other concurrency issues. Any ideas how this could be done?

SashaR

There wont be a way to include formulas when moving rows between sheets but I have a couple ideas.

If the formulas are identical across your sheets then once the row is moved, you could drag fill the formula down from the row directly above the moved row. This is an extra step but would only take a couple seconds.

My other idea is to use reports (may or may not work depending on your processes and how your sheets are set up). Instead of moving rows between sheets, each team member can have their own sheet but use reports to bring in rows from everyones sheets into a single location. Each team member could have their own report or they could share. Reports are editable and easily modified so it pulls in the exact rows you are looking for. More on reports from the help center: http://help.smartsheet.com/customer/portal/articles/522214-creating-reports