Approach to count new rows by day for reporting

We are using smartsheet to track issues from UAT and I want to be able to report on the number of issues added each day, and closed each so I can create a bar chart for the dashboard.

I was able to calculate the number of new each day with this formula using the system created date column.

I have a field for status and I believe that when I change the status to closed I should be able to use the modified colum.

=COUNTIF(Created:Created, =(TODAY()))

Thanks for the assistance

Find more posts tagged with

Formulas

Accepted answers

All comments

David Tutwiler

CountIfs I believe is what you're looking for.

=COUNTIFS(Created:Created, TODAY(), Status:Status, "Closed")

Ramzi K

@Andrew Mack

One way to do it is:

For number Open I would use the =COUNTIF(Created:Created, TODAY()) as you did

For number Closed, I would include the Status as well to make sure that nothing else in the issue was changed that caused the Modified date to change.

=COUNTIFS(Modified:Modified, TODAY(), Status:Status, "Closed")

This assumes you have a column called Status that has the value Open or Closed.

Note: Both Created and Modified columns are system date columns.

I hope this helps.

Ramzi

Andrew Mack

Thanks for the suggestions. I also wanted to know how to track the new and closed issues over time. I I would like to be able to create a bar chart that show opened and closed issue count by day

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.