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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!