Sumifs Smartsheet multiple criteria assistance

jcharger13

Hello, I am needing assistance with trying to create a formula in Smartsheets that will count the duration of time for a specific Person/Year. Any help would be appreciated.

EX:

Data Sheet:

Metric Sheet:

Looking for a return on the Metric Sheet to read:

Paul Newcome

Try something like this in the cell in [Column2]2 and then dragfill down and to the right.

=IF(SUMIFS({Duration}, {Employee}, @cell = $[Primary Column]@row, {Date}, IFERROR(YEAR(@cell), 0) = [Column2]$1)> 0, SUMIFS({Duration}, {Employee}, @cell = $[Primary Column]@row, {Date}, IFERROR(YEAR(@cell), 0) = [Column2]$1))

jcharger13

I tried that but I get an Unparseable response. Also the data it is reviewing is on another Smartsheet (an input sheet). So I think that is why it isn't pulling any data and returning an error.

jcharger13

I also tried this variant without any luck:

Paul Newcome

Your first formula should have square brackets around cells being referenced that are in teh same sheet as the formula.

{column2}$1

should be

[column2]$1