Sum formula that references other sheets

I'm trying to Sum together information from 4 separate sheets. I can easily accomplish this by referencing each sheet/cell within the SUM() formula, and it works great. The problem that I'm running into is duplicating this formula to the remaining 364 cells that I'm trying to populate. Can I use the $ symbol somehow for absolute cell reference for another sheet? The sheets that I'm pulling info from are all identical layout to each other, but represent information across 4 different districts.

Answers

  • M Underbrink
    M Underbrink ✭✭✭✭✭

    You'll be interested in the reporting updates announced at Engage this year that include the ability to do SUM and other basic functions on reports. Because reports can pull from multiple sheets, I assume this will meet your need. I think the reporting updates were coming in November or January if I recall?

  • I'm also interested in this, if anyone has found a way. The report does work great for this, BUT when pulling that data on a dashboard, it also shows all the numbers in a cluster over the graft. This isn't feasible for client solutions. So in this case, we would need a sheet formula that has the same SUM function as the report, because it displays where clients can read and understand the information.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!