Referencing a column from the top down to the current row - WITHOUT ABSOLUTE REFRENCE
I am trying to refer to a column from the #1 row down to the current row in a formula
For example say I have a column called Monthly Cost, I could have a formula
=SUM( [Monthly Cost]$1:[Monthly Cost]@row)
And that formula will very nicely give me a running subtotal line by line
Except for one issue - I want to make it a column formula - and Smartsheet does not like absolute references in column formulas
Smartsheet does not like
=SUM( [Monthly Cost]:[Monthly Cost]@row)
that is apparently a syntax error.
Any ideas on how to reference a column from row 1 to the current row without using an absolute cell refrence ?