Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formulas lost when moving rows within sheets

edited 12/09/19 in Archived 2016 Posts

I keep an 'active projects' sheet, and move projects to an  'inactive' sheet to keep the clutter down. The formulas do not move with the rows though, which is annoying (sometimes projects come back to the 'active' sheet when new samples come in, and I am now  having to copy and pasting formulas into those cells). Any suggestions on how to avoid this issue?



  • Maaik Meijerink
    Maaik Meijerink ✭✭✭✭✭

    Hello MVignali,


    I have encountered the same problem.


    In stead of moving the 'inactive projects' to another sheet, within the same sheet, I made a parent 'Inactive Projects'.

    By selecting the inactive projects and moving them below this Parent, you can keep the clutter down.


    To add an extra visual aspect, I used a checkbox-column ('inactive'), when if checked, the conditional formatting results in strike-through text.


    To make the projects come back again, you only need to move the rows back where they came from. Formula's like SUM(CHILDREN()) will still work.



  • MVignali
    edited 03/29/16

    So you just keep it all at the end of the list, under a row labelled "Inactive Projects"?
    That could work, thanks.


    However, I would still like to move them to a different SS while keeping the formulas. Maybe someone else has an idea of how to make that happen.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 03/31/16

    Copy / Paste instead of Copy Row to Another Sheet.

    And I mean Copy all the cells in the row, not select the row.

    I don't have a problem with formulas moving -- unless they are referencing something outside the range of the copy.



  • ah. I was moving row to the other sheet. I will try this. thanks.

This discussion has been closed.