Sum Data From two sheets

I am trying to sum data from two sheets, which I have figured out but I want an equation I can bring down the whole role.

=SUM([Month to Date Actual]@row, {Sheet - (01-January) Range 3})

I do not want to do this on every sheet, I want to that. like in excel I can us for the whole row.

Help please


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!