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)
