Best Practice for Multiple Sheets with Column Formulas

electrichead

On my Smartsheet I have multiple sheets.  Requests come in on the Request sheet, then move to an Approved, Hold, or Rejected sheet.  I'm wondering if some of the column formula's I have should be removed from the all but the Request sheet.  Those formula's are meant to provide guidance on what action should occur with a request.  And, after a project moves to a new sheet recalculating them isn't necessary unless it gets moved back to Requested status (and sheet).  Also, and this drove the question, as I update some of the formula's on the requested sheet I notice it gets messy with other sheets that may have older requests that don't follow the same requirements as new ones.

Do you have any experience or thoughts to lend here on which way I go with it?  Should I only keep the column formula in the Request sheet?  Or continue to update all the sheet column formulas (currently I try to keep them the same)?

Paul Newcome

If you do not need them to calculate on the other sheets, I would remove them from the other sheets.

Paul Newcome

If you do not need them to calculate on the other sheets, I would remove them from the other sheets.