Is it possible to do calculations between Summaries of 2 different Sheets?

Lucinda Marinus

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!

James Keuning

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

Lucinda Marinus

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.