Unparseble AND in a COUNTIFS

I and trying to count rows where range 1 (last modified date) is 8 days ago AND range 2 (project status) = "In Progress"

=COUNTIFS(AND({Master Project List Range 1} > (TODAY() - 8)), Master Project List Range 2 = "In Progress")

Can't seem to get the syntax right

Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    edited 01/20/22 Answer ✓

    The COUNTIFS function counts if all the criteria evaluate to true. You don't need the AND function here. But you do need to have criteria range and criteria separated by commas. Try this:

    =COUNTIFS({Master Project List Range 1}, > TODAY(-8), {Master Project List Range 2}, "In Progress")

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Answers

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    edited 01/20/22 Answer ✓

    The COUNTIFS function counts if all the criteria evaluate to true. You don't need the AND function here. But you do need to have criteria range and criteria separated by commas. Try this:

    =COUNTIFS({Master Project List Range 1}, > TODAY(-8), {Master Project List Range 2}, "In Progress")

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!