SUMIFS; Need to know how much time is allocated to each cost center by employee


I am trying to figure out how much time is allocated to each cost center for each employee for the 3rd Qtr.

Placing a formula into a metric sheet trying to reference the original sheet didn't go well, so I moved to using the below formula in the "sheet summary' in an attempt to roll up how much time per one cost center (001064) is for Marian.

=SUMIFS([3rd Qtr (Jan 1 - Mar 31)]:[3rd Qtr (Jan 1 - Mar 31)], [Allocated Department]:[Allocated Department], @cell = 001064, [Join]:[Join], @cell= "Altman, Marian S.",))

I am getting #UNPARSABLE

Any suggestions?


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!