SUMIFS in a Dashboard or Report that references another sheet

Options
MattS
MattS
edited 12/09/19 in Formulas and Functions

Hello!

I'm looking to utilize a Dashboard or Report and can't, for the life of me, figure out the best way to do this.

I need to give a summary of units sold to a customer, per product type, per year. See attached screenshot.

Questions or need additional information, just let me know.

Thanks,

Matt

Screen Shot 2019-03-04 at 3.26.44 PM.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!