Formulas

CherylAK

Is is possible to write a formula based on information in one sheet to put the result in a cell of another sheet?

I want to sum items if they meet certain criteria in one sheet but the result going in a cell in another sheet.

 

Thanks!

 

 

 

Mike Wilday

Yes, it is using cross sheet formulas. Check out these articles/videos for more information: 

• https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
• https://www.smartsheet.com/blog/powerful-and-flexible-cross-sheet-formulas
• https://www.youtube.com/watch?v=u01GHwmlDRA

CherylAK

Thank you!