Running Budget

Margaret Evans

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.

=[ENDING BUDGET]15

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)

Ending Budget Number Brought to the Top.GIF

Leibel S

Try the below formula into your top line.

=INDEX([ENDING BUDGET]:[ENDING BUDGET], COUNT([ENDING BUDGET]:[ENDING BUDGET]) + 1)

This would only work if you do not have empty rows in between...

Leibel S

Try the below formula into your top line.

=INDEX([ENDING BUDGET]:[ENDING BUDGET], COUNT([ENDING BUDGET]:[ENDING BUDGET]) + 1)

This would only work if you do not have empty rows in between...

Margaret Evans

EXCELLENT! PERFECT!!

Thank you so much!!!

I hope you have a very Happy Thanksgiving! :p)