Sending data to another sheet leaves formulars behind. SMART SHEEET I HAVE AN IDEA !

Heath Sanders

Back in Feb 2017 I spoke about (When sending a row to another sheet it leaves the formulas behind). It was explained to me that it dose this to avoid errors etc.

The problem I having is that the sheet I'm building is so interactive meaning: (I send on the row when job is sold to accountant, he then fills in his data, send it on to installer. He fills in his data and sends it to complete sheet. Each time the row is sent to another sheet I.e. Accountant or Installer,  the rows that don't relate to them are hidden (So their sheet looks different to mine when it actual is the same)  My question to Smart Sheet is if you "Save As New" or set up an option (Save As Cluster) that allows those sheets to be interactive. This means when a cluster of sheets ( Sales Rep: Accountant: Applicator: etc  requires the same "Formulas" to carry over to the sheets just like the "Conditional Formatting" dose when you "Save as New". This would make the sheet a very powerful interactive tool don't you think ?

Thank You

 

 

Shaine Greenwood

Hello Heath,

Formulas are preserved in copies when you perform a save as new on sheets. 

If you're experiencing a different behavior, please reach out to https://help.smartsheet.com/contact

Heath Sanders

Hello Shaine,

So each time we up date a sheet (Lets say there are five in the group) We need to "save as new" four more times so all five sheet duplicate each other (Formulas, Conditional Formatting Etc Etc when we send data across the sheets it will be the same all the time ???

Thanks Shaine