COUNTIFS formula between a specific date range

Options

Hello SmartSheet Community! I am trying to write a formula that will capture project deliverables status between a specific date range and I keep getting an error. I thought the below formula would work, but I am wrong, lol. Any ideas?

=COUNTIFS(Status:Status, "Not Started", ([Start Date]:[Start Date], >=DATE(2022, 10, 1), ([End Date]:[End Date], <=DATE(2022, 12, 31))))

Tags:

Best Answer

  • Ryan Sides
    Ryan Sides ✭✭✭✭✭✭
    Answer ✓
    Options

    @Dan H

    Hi Dan, I think your parenthesis were out of whack 😁

    =COUNTIFS(Status:Status, "Not Started", [Start Date]:[Start Date], >=DATE(2022, 10, 1), [End Date]:[End Date], <=DATE(2022, 12, 31))

    Try that one ^ and please let me know if it works for you.

    Ryan

    Ryan Sides

    Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube

    Come Say Hello!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!