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 ?


Thanks

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!