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

Find more posts tagged with

Accepted answers

Paul Newcome

Try this...

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

All comments

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.