Hello,
I have been struggling to locate a solution for my current predicament. I have spreadsheet of customer service inquiries, which includes both the date created and date last modified in two respective columns.
I am making a dashboard to breakdown date ranges of the inquiries. I have performed counts of all inquiries from today, all inquiries from this month, and all inquiries to date. Each inquiry also has a status (open or resolved). Now I am working on getting counts for how many inquiries were resolved on the same day for each of those sub-counts (i.e. how many inqueries were resolved today, how many resolved on the same day for this month, and how many total resolved on same day).
For the cell where I am trying to compute the total inquiries responded to on same day this month, I am running into some issues and am not sure how to add in the criteria for it to count when the created date column equals the last modified date, and the status is set to "resolved."
Here are the current cells for the dashboard and the corresponding formulas I have to give you a better idea:
Total inquiries today: =COUNTIF('Raw Data'!J2:J1048576,TODAY())
Total inquiries this month: =COUNTIFS('Raw Data'!J:J,">="&DATEVALUE(MONTH(TODAY())&"-1"&"-"&YEAR(TODAY())),'Raw Data'!J:J,"<"&DATEVALUE(MONTH(TODAY())+1&"-1"&"-"&YEAR(TODAY())))
Total inquiries to date: =COUNT('Raw Data'!A2:A1048576)
Total inquries responded to today: =COUNTIFS('Raw Data'!J2:J1048576,TODAY(),'Raw Data'!D2:D1048576,"Resolved")
Total inquiries responded to same day this month: ???? NEED HELP!!!
Total inquiries responded to same day to date: =COUNTIF('Raw Data'!D2:D1048576,"Resolved")
Please help - and let me know if you need me to clarify anything. Thanks.
Bookmarks