Total the duration of all tasks

This discussion was created from comments split from: Does not contain this OR that.


  • Chris Jernigan

    I have a similar issue.

    I want to total the duration of all tasks based on Work Type if they are not complete.

    I have a duration column, Work Type column, state column.

    The issue I am hung up on is that the Work Type column could have multiple types sometimes.

    Doubt I am close but here is what I have:

    =SUMIFS(Duration:Duration, Work Type:Work Type, (CONTAINS("SQL")), State:State, NOT(CONTAINS("Complete")))

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    You're actually not that far off. There were a few unnecessary closing parentheses. Does this work for you?

    =SUMIFS(Duration:Duration, Work Type:Work Type, CONTAINS("SQL", @cell), State:State, NOT(CONTAINS("Complete", @cell)))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!