Tasks not started


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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!