Need total rows by date to compare from 2 separate worksheets.

I have data from 2 different years, 2023 and 2024, soon to add 2025 :). I am trying to count the total number of rows on each sheet by date they closed, and then do a summary sheet or report to show total number of closures by each date (regardless of year). So as example, in 2023 on 1/10/23 I had four items closed, in 2024 on 1/10 I had 1 item close. I want to ideally do a line graph that shows 1/1 - say 3/1, with the volume that closed each day, one line to show 2023, one line to show 2024. Is there a "simple" way to do this?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You would add each month or range of months on each row.

1/1 - 3/31

4/1 - 6/30

so on and so forth.

Then you would use a COUNTIFS. You would have separate years as columns.

=COUNTIFS({Source Sheet Date Column}, OR(IFERROR(MONTH(@cell), 0) = 1, IFERROR(MONTH(@cell), 0) = 1, IFERROR(MONTH(@cell), 0) = 3))

Jenn F.

So I'm confused - by the first part of the solution - "add each month or range of months on each row" - can you give me more substance here? I'm a noob on this part of Smart Sheet sadly :(

Paul Newcome

I believe I misunderstood your original ask. My apologies. You would create a sheet that has each day within the date range listed down a date type column (called "Dates" in this example).

1/1/2025

1/2/2025

1/3/2025

so on and so forth.

Then you would have separate columns for each year and use a formula along the lines of

=COUNTIFS({Source Sheet Date Column}, AND(IFERROR(DAY(@cell), 0) = DAY(Dates@row), IFERROR(MONTH(@cell), 0) = MONTH(Dates@row), IFERROR(YEAR(@cell), 0) = 2025))

You would just need to change that last 2025 to whatever year you need in each of the columns. Then you would graph this table that you have created.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.