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.
Sending data to another sheet leaves formulars behind. SMART SHEEET I HAVE AN IDEA !
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 ?