Cross sheet sum if

Garmon D
Garmon D ✭✭✭
edited 12/09/19 in Formulas and Functions

I'm creating a sheet to record the use of agency/contracting staff across a site (once the proof of concept is done it'll be expanded to cover multiple sites), where entries will be added to the sheet below via form. The "within budget" column on the 1st sheet should be picking up any entry from the  Month Total Spend (MTD) col on the second sheet where the Year and Month column match on both sheets. The formula is below:

=SUMIFS({Sheet - Unit 1 Agency Budget Alert Range 2}, {Sheet - Unit 1 Agency Budget Alert Range 1}, =Month2, {Sheet - Unit 1 Agency Budget Alert Range 3}, =Year2)



Any thoughts much appreciated!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!