How to report by date
I am pretty new to Smartsheet and have done the basic training on sheets. I want to track calls received in a call center by date. So it is a simple count of rows by date, with a number for each date 1 or more calls was received. I have worked out a summary that gets me the total calls over a date range, but I have not worked out how to break it out by date so I see how many calls came in on each date.
Best Answer
-
Thank you. I worked it out using a report based on my call tracking sheet. Was able to then put a chart on a dashboard showing call counts by date.
Answers
-
You would probably benefit from using a metrics sheet to do this.
Create a date column in the metrics sheet, with a date on each row. In a count column, use a COUNTIF to find the total # of calls that match that row's date:
=COUNTIF({Call Log Sheet Date Column}, Date@row)
where {Call Log Sheet Date Column} is a reference to the Date column in your call log sheet.
(When typing your COUNTIF formula, when you get to the opening parentheses [ =COUNTIF( ], Smartsheet will provide a link to Reference Another Sheet. Click on that, find your call log sheet, and select the Date column.)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thank you. I worked it out using a report based on my call tracking sheet. Was able to then put a chart on a dashboard showing call counts by date.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 75 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!