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!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!