COUNTIFS Function - 0-30, 31-60, 61-90, >90 Days


I am looking to pull the total number of unassigned projects with 0-30, 31-60, 61-90, >90 Days. The "Completed" column is the date the form is submitted. I am getting a value of 0 when using the formula below. Thoughts?

=COUNTIFS(Status:Status, "Unassigned", Completed:Completed, AND(@cell >= TODAY(), @cell <= TODAY(+30)))

=COUNTIFS(Status:Status, "Unassigned", Completed:Completed, AND(@cell >= TODAY(31), @cell <= TODAY(+60)))

=COUNTIFS(Status:Status, "Unassigned", Completed:Completed, AND(@cell >= TODAY(61), @cell <= TODAY(+90)))


Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!