count incomplete tasks due in next 30 days

amassa

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!

Nick Sor

Hello,

Try using this formula

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

Nick Sor

Hello,

Try using this formula

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

amassa

That worked. Thank you!