Is it possible to do calculations between Summaries of 2 different Sheets?
Options
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!