Smartsheet Reference Formulas Not Summing
I've created a Smartsheet that sums various other referenced Smartsheets. Formulas sum values in entire columns of the referenced sheet.
When I sort columns in the referenced Smartsheets, the values in the summary Smartsheet change even though the entire columns are included in the formula. How to I fix this?
Answers
-
Please provide the formula you are using.
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!