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.
=[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)
Best Answer
-
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...
Answers
-
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...
-
EXCELLENT! PERFECT!!
Thank you so much!!!
I hope you have a very Happy Thanksgiving! :p)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!