Creating a master budget file from multiple project budgets

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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!