Calculating the Number of Tickets Opened

nkosikhona.msani89271

Hi There,

I am currently building a Dashboard and I want to show the number of Tickets that have been opened for a certain period, e.g. the number of tickets opened with a week.

Is there a formula that I can use to achieve this.

 

Paul Newcome

Yes. You would use a straightforward COUNTIFS for this...

 

=COUNTIFS([Date Column]:[Date Column], DATEONLY(@cell) >= TODAY(-7))

 

This will give you within the past 7 days. If you needed a different date range, you would just have to modify the criteria to reflect that.

nkosikhona.msani89271

Hi Paul, Thank you it worked.

Paul Newcome

Happy to help!