Creating a master budget file from multiple project budgets
Options
I am trying to create a master budget file for tracking budgets and spending across several sheets, but I am struggling to come up with a solution that would enable me to drag the cell references across, like you can do in excel where it dynamically changes the cell reference.
The sheets are structured with a budgetline description, Total Budget and then a monthly Actuals column for each month, that I would need to roll up into a master budget sheet.
is there a way to do this?
Answers
-
Have you looked into creating a report instead?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!