CountIf and Date formula combination

I need to calculate the number of roles in any given month. I have a seperate sheet with Hires, Roles, Start Date, and Productivity Date. The count should start two weeks after hire date , which is why there is a productivity date.

In another sheet I want to calcule how many roles are active in any given month. The formula that I am using , unsuccessfully, is : =COUNTIFS([Role]:[Role], "A", [Productivity Date]:[Productivity Date], @cell>DATE(2020, 4, 17)

It's not working though. Any suggestions on getting it fixed or another alternative?


  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    =COUNTIFS([Role]:[Role], "A", [Productivity Date]:[Productivity Date], @cell>DATE(2020, 4, 17))

    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!