Total the duration of all tasks

System · 03/15/21

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

Chris Jernigan · 03/12/21

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 · 03/15/21

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)))

CONTAINS Function | Smartsheet Learning Center