Is it possible to do calculations between Summaries of 2 different Sheets?
Hello,
I'd like to calculate a value that is simply a subtraction of Summary fields on 2 different Sheets. It's ok if the calculation formula is on a sheet, a report, or a dashboard, doesn't matter. I just need Smartsheet to subtract the two Summary fields.
I am a beginner user so any help is appreciated. :)
Thank you!
Tags:
Answers

Have you successfully performed any sort of crosssheet reference? You can reference the Sheet Summary field in a cell by using =[Summary Field]#

Yes, thank you. I can create a reference to a Sheet Summary field on the same sheet. Where I'm having trouble is referencing a Sheet Summary field on a different sheet.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 348 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!