Sumifs error formula when summing duration time

HI, I have a metric sheet where it is comparing to see person exists on another sheet and if so calculate the durations assigned against all their tasks.

I get an #UNPARSEABLE in the formula that I cant figure out. Can anyone advise?

=SUMIFS({Michael Johnson Assigned to}, [IT Personnel w no Email]@row, {Michael Johnson duration}, >1)

This is my target sheet

This is my source sheet



Thanks

Best Answer

  • DKazatsky2
    DKazatsky2 ✭✭✭✭✭
    Answer ✓

    Hi @Graeme Baxter,

    Try changing your formula to this: =SUMIFS({Michael Johnson duration}, {Michael Johnson Assigned to}, [IT Personnel w no Email]@row, {Michael Johnson duration}, @cell > 1)

    I am assuming you are failing on {Duration} because you don't have that as a reference.

    Hope this helps,

    Dave

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!