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

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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!