Tasks not started

Molly Sudmeier

i'm trying to calculate the number of tasks not started (out of the box functionality for the accelerator that I had to repair)

I'm trying to look at those that are tasks (so non-tasks are not checked), Percent complete is 0, and that have a task associated with them (so we aren't counting blanks).

-Project Schedule Range 4 = Non-Task (check box)

-Project Schedule 5 = Percent Complete

-Project Schedule Range 1 = Task Name

I'm getting unparsable.

=COUNTIFS([{Project Schedule Range 4}, 0,{Project Schedule Range 5} = "0%"), {Project Elevate - Project Schedule Range 1}, NOT(ISBLANK())

Paul Newcome

Try this...

=COUNTIFS({Project Schedule Range 4}, 0, {Project Schedule Range 5}, 0, {Project Elevate - Project Schedule Range 1}, @cell <> "")

Paul Newcome

Try this...

=COUNTIFS({Project Schedule Range 4}, 0, {Project Schedule Range 5}, 0, {Project Elevate - Project Schedule Range 1}, @cell <> "")

Molly Sudmeier

Hmmm...I'm getting Incorrect Argument...Yeesh.

Paul Newcome

=COUNTIFS({Project Schedule Range 4}, @cell <> 1, {Project Schedule Range 5}, 0, {Project Elevate - Project Schedule Range 1}, @cell <> "")

If that doesn't work, can you provide a screenshot of the source data?