Sign in to join the conversation:
I am able to calculate today number of requests and total number of emails.
I want to be able to calculate requests per day and emails per day.
What is best function to use?
Maybe COUNTIFS
Craig
Thanks Craig. I tried that formula and cant' seem to get it to work.
Thanks,
Barb
This would show the number of times that [Request Date] matches the date in the same row.
=COUNTIFS([Request Date]:[Request Date], [Request Date]@row)
This would show the number of emails per day
=SUMIFS(Emails:Emails, [Request Date]:[Request Date], [Request Date]@row)
I would use this in a header section, not on each row, but either works and has use cases. If I want to reuse the [Request Date] in my header, I would also check if the Brief Desciption column was blank, so I didn't count the header section by mistake
=COUNTIFS([Request Date]:[Request Date], [Request Date]@row, [Brief Description of Request]:[Brief Description of Request], NOT(ISBLANK(@cell)))
=SUMIFS(Emails:Emails, [Request Date]:[Request Date], [Request Date]@row, [Brief Description of Request]:[Brief Description of Request], NOT(ISBLANK(@cell)))
I hope that helps.
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
