COUNTIF to determine the number of tickets created in a given month.

Andres Valdivieso · 09/24/20

Hello,

I am trying to figure how many tickets have been created by month using the formula below, but getting unparseable result.

Any help is much appreciated.

=COUNTIFS([Created Date]1:[Created Date]300, AND(@cell >= DATE(2020, 5, 1), @cell <= DATE(2020, 5, 31)))

Thank you,

John Jonassen · 09/24/20

Try this:

=COUNTIFS([Created Date]:[Created Date], >=DATE(2020, 5, 1), [Created Date]:[Created Date], <=DATE(2020, 5, 31))

Tana Rucker · 09/24/20

Another solve could include the pivot app.

John Jonassen · 09/24/20

Try this:

=COUNTIFS([Created Date]:[Created Date], >=DATE(2020, 5, 1), [Created Date]:[Created Date], <=DATE(2020, 5, 31))

Andres Valdivieso · 09/24/20

Thank you @JohnJonassen, this worked perfectly.

Tana Rucker · 09/24/20

Another solve could include the pivot app.

Smartsheet Basics