How to copy paste a SUM function that is referencing to other sheets
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!
Help Article Resources
Check out the Formula Handbook template!