Task is open and overdue

I know that I'm super close on my formula but it's returning an Incorrect Argument. I have a list of contracts and when they are expiring. I want to know how many: are over due; coming due in 30 days; coming due in 60 days. I am having it look in the "Completed" column and if it is not checked to then go to the "Completion Date" column and let me know those that have a date equal or less than today's date. Starting on the overdue one, I have the following:

=COUNTIF((Completed1:Completed9), =0, AND([Completion Date]1:[Completion Date]9, <=TODAY()))

This is returning the Incorrect Argument so I think that it's just down to a bracket missing somewhere but I've tried all different combinations.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!