Running Budget


Hi, I am working on a Daily Expenditure Report and on the top line where normally we would add everything below it for a grand total... but in this case, I need to know what the ending balance is, rather than a total for all expenditures.

I tried this, but it references a specific line below.


If I add more rows due to more spending, I need for Smartsheet to grab the bottom number whether its 5 rows down or 150 rows down.

I tried @row, but it's a circular reference.

I need to bring up the last number whatever row it ends on ($74,786.22) to the top cell. Hope this makes sense.

Anyone? :p)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!