Calculating the Number of Tickets Opened

nkosikhona.msani89271 · 09/26/19

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 · 09/26/19

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 · 09/27/19

Hi Paul, Thank you it worked.

Paul Newcome · 09/27/19

Happy to help!

Calculating the Number of Tickets Opened

Comments

Help Article Resources

Categories