COUNTIFS Formula Question

Dan H
Dan H ✭✭✭
edited 06/20/22 in Formulas and Functions

Hello, I am trying to use the COUNTIFS formula to capture the status of a project between a date range, and I am not able to figure it out. The formula I have is below, but I keep getting #UNPARSEABLE. I have tried several different versions of this with no luck. Any help would be greatly appreciated.

=COUNTIFS(Status:Status, "Released", Status:Status, "Released")), AND([Status Change Date]:[Status Change Date], >=DATE(2022,01,01))


Best Answer

  • Sing C
    Sing C ✭✭✭✭✭✭
    Answer ✓

    Hi @Dan H ,

    Try this:

    =COUNTIFS(Status:Status, "Released", [Status Change Date]:[Status Change Date], >=DATE(2022, 1, 1))

    This counts the number of rows where the status = Released and date is on or after the start of this year.

    Hope that helps. Let me know if that works for you.

    Thanks!

    Sing Chen

    Process Architect, Ceridian

    LinkedIn

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!