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  (01January) 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
Answers

@MKV Do you mean row or column? Do you want to make the formula a Column Formula?
Is that what you are after? Not sure that formula works as a column formula ...
dm

@Dale Murphy That did not work, I tried that earlier, it only pulls in the data form the main sheet correctly, it does not pull in the second figure from the data sheet, it just stays with the first row number on second data set.
Otherwise that would have worked
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!