COUNTIFS box checked and End date 3 months from now

Hi, I am having trouble with counting how many projects, that have Global Report checked, are due to end within the next 3 months.

I wrote the following formula, but it returns invalid operation, could someone please help me out?

=COUNTIFS({ Global Report}, 1, { Project End}, AND({Project End} >= TODAY(90), {Project End} <= TODAY()))

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!