How to copy paste a SUM function that is referencing to other sheets


Hi all,

I have sales data per month for a year, for several regions, each region has its own sheet. When I want to make 1 summary table, I think I need to use =SUM(number 1, number 2, ...and so on) and for each number, reference to another regional sheet. In Excel, if I create this formal for January once, I can then drag the cell to copy the formula for all other months. When I do that in Smartsheet, it will keep the formula for January intact. How can I easily create a formula for 1 month and then copy it over to other months? I want to prevent to be typing the same formula 12 times, since I need to reference quite a number of sheets each time.

Thanks for your help again!

Kind regards



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!