Hi Richard,

When you expand a SmartSheet, this creates rows based on the formulas and formatting of the original row that has .Range in column A.

If you collapse a SmartSheet, this deletes all of the generated rows, not just hiding the rows.

Because of this, you don't want to be making adjustments to cells in generated rows, because as soon as you refresh (or collapsed and re-expand), those changes will be gone. Or basing formulas on cell references to generated cells, because it will get changed the next time you collapse the sheet.

It will be tricky to attempt to add the amount of a specific cell that is found in a generated row with another cell that is not generated. This has to do with cell-referencing and that the depreciation amount is not guaranteed to always be in the same row (depending on zero-suppressed rows or if you add new accounts). You would be better off having the depreciation account in a separate row of the report, not getting generated and thus not subject to the whims of an unexpected cell-reference or being deleted.

To hide particular Generated rows, you cannot use the 'Hide when Printed' format, but you could potentially hide the rows. This would involve using the 'RowFormat' function to conditionally hide a generated row, based on criteria you can define in an IF formula. This is done by putting .RowFormat in the top-right cell, and a formula such as the one's below in the the right-most column, in a row with .Range in column A.

=IF($B10 = "1000" , "FormatHidden" , "")
=IF($D336 >= 5000 , "FormatHidden" , "")