Try entering the formula in the collapsed mode. Any row that is generated from expanding the smartsheet will copy the formulas from the collapsed row that generated it.

----------------
Don Wise
Westboro