count incomplete tasks due in next 30 days

I am trying to create a summary field on my project schedule that counts the number of tasks due in the next 30 days. I know a task is still open based on the % Complete (text/number field, formatted as %).

I have tried the following formula based on other feeds and get an error:

=COUNTIF([Finish]:[Finish], >Today(),[Finish],[Finish], <=Today(30), [% Complete]:[% Complete],<1)

If I use a text field, like a dropdown Status of "Open", then it works. But I don't want to add another field to maintain or even autofill.

Thanks for the help!

Find more posts tagged with

Accepted answers

Nick Sor

Hello,

Try using this formula

=COUNTIFS(Finish:Finish, AND(@cell > TODAY(), @cell <= TODAY(30)), [% Complete]:[% Complete], <1)

All comments

Nick Sor

Hello,

Try using this formula

=COUNTIFS(Finish:Finish, AND(@cell > TODAY(), @cell <= TODAY(30)), [% Complete]:[% Complete], <1)

amassa

That worked. Thank you!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.