Sumifs returning #unparseable counting RAID due within 7 days

Hello - Receiving an #unparseable error when counting RAIDs due within 7 days. screenshot of the columns status and due date.

Formula -

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    The most immediate issue is the closing parenthesis after the [Due Date]:[Due Date] range. It needs to be removed.

    If you are trying to get the count for within the next 7 days, this should work for you:

    =COUNTIFS(Status:Status, @cell <>"03 Closed / Deferred", [Due Date]:[Due Date], AND(@cell<=TODAY(+7), @cell>= TODAY()))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!